Register
Log In
Unanswered
Home
New Member
March 29, 2017
Offline
Hi everyone,
I am looking to print specific sheets of an excel workbook based on a data table.
In the "Control Sheet" of my sample file, I have a list of Student IDs. The first Student ID is copied in E2, and then the table shows which pages the student needs (YES/blank). The macro then prints only the sheets that have a value in column B to create a booklet tailored to each student (rather than printing all the sheets).
For the most part my code is working, I just can't get the macro to loop through the list of Student IDs. As of now, it only copies the first Student ID on the list into cell E2 and prints. Since I have so many students, it would be a great help to print the sheets for all my students automatically.
Eventually I would also like to save the booklets as PDF's and send them to each student.
I am quite new to VBA and would really appreciate any help you are able to provide. Thanks so much!
Warm regards,
Jacqueline
Dashboards
June 25, 2016
Offline
Hi Jacqueline
See if this helps.
I have added a macro that will print the required sheets for each student to individual PDF.
It will read the data from the Data Dump sheet and will ignore any sheets not found e.g. PAGE 7, PAGE 8 etc.
IMPORTANT : Please change the output folder (in the macro) to where you want the PDF files to be saved.
More instructions are included in the attached.
Cheers
Sunny
New Member
March 29, 2017
Offline
Wow thanks so much Sunny for your work, this works great!!!
Is it possible to incorporate this macro into the "Control Sheet" tab? Sorry I should've clarified earlier, I would love to be able to choose a list of student ID's and have it print those booklets (rather than always having to print everything from the data table).
My only other question is if I can manipulate that Print to PDF macro and have it send to the students emails? So for example, if I have a table with the student ID in column A, email in column B, and the filename path in column C-Z all in the "PrintoPDF"tab. I found a macro code that I have added to the workbook but can't seem to get working. I think its the filename that's the problem? I have used the excel function =CELL("filename") to retrieve it but I must be missing something.
Thanks!
Warmest regards,
Jacqueline
Dashboards
June 25, 2016
Offline
Hi Jacqueline
Attached is the revised print to PDF file. It uses Data Validation to select the ID and then print.
The second file is a utility to send e-mail modified from my own files (not 100% tested due to lack of time, but working so far).
The e-mail is currently set to Save. Change if you need it.
Hope this helps.
Sunny
Most Users Ever Online: 57
Currently Online:
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
