That is super helpful, thank you for the video. One question though: if I need to select specific data (not just one or all of them), let's say I only need the active workers' reports and not all the workers' reports in the file, how should I do it?
Thank you very much and it works perfect. I do have a question though. Lets assume you work with a big data set, lets say 500. But you want to exclude some of it. Let say you want to print 1 - 150; then don't print 151 to 200; then print 201 to 300, exclude 301 to 350 and then print the rest till you reach 500. Can you please help with this
Hi thank you! I think this is something amazing that not many people know about.. it certainly helped me in my tasks. It seems I have forgotten to include the code in the description - I'm surprised no one else has asked. Once I get home today I will go looking for it, put it in the description and ping you. Thanks for watching and be sure to tell your friends if you it was really helpful!
@@henryouang Perfect, thank you! I thought I was crazy that I couldn't find the coding. Actually, I have a complicated question. I want to use what you show in the video with an Excel web spreadsheet generated from a Microsoft Form. Is this possible?
So Awesome, Henry!! Thanks a ton. I'm a novice and you made this soooo easy. Only thing I'm having trouble with is saving the pdf's to a network (MS Sharepoint) file path that start out . Can this be done? Thanks!
Hello, i have a question, would it be possible if printing all records into one pdf (each page is a record)? would be greater even! thanks for this so much!
When I heard VBA …I got scared. But I followed through lol. I am going to test on my side. My data is not in a simple list but in a template form that is similar
Hello how would I make a macro that prints based on a certain field, for example I have a field with dates and I want to make a pdf of all the records done on that specific date, thanks in advance!
hi Henry, thanks looks great ... can you do this also in Microsoft word? is it also possible to use this for invoicing (eg with several line items related to one recipient merged in one pdf? Zsolt
Hi, I believe it can be done in word as well with a ton of customization. The invoice lines can probably be done as well but I haven't spent time thinking of how to do that yet. You could just do invoice lines in excel perhaps?
I had about 40 pdfs to create and 4 said the same. No idea why...rest generated perfectly. I see in the code that that is the message that is supposed to pop up when there's an error. Update: Found the issue. File explorer does not allow special characters in file names - I had a ":" in the generated file name which caused the error...
Thank you for this two-part series!
You explained every aspect and supplied free code!
Amazing!
AMAZING!!! I finally got an long term issue solved thanks to you!
You absolutely help my task Henry, thank you so much
Never used these items in Excel - super helpful!
This’s so helpful. Thank you million times for doing such a good clip!!
BRILLIANT!!! Thank you so much! You are STAR!!
Thank you for helping and making it easy and straightforward
That is super helpful, thank you for the video. One question though: if I need to select specific data (not just one or all of them), let's say I only need the active workers' reports and not all the workers' reports in the file, how should I do it?
What if there is a dropdown list on the print area and data changes based on dropdown list
Thank you very much and it works perfect. I do have a question though. Lets assume you work with a big data set, lets say 500. But you want to exclude some of it. Let say you want to print 1 - 150; then don't print 151 to 200; then print 201 to 300, exclude 301 to 350 and then print the rest till you reach 500. Can you please help with this
Is it possible to email the pdf instead of save? So that is 10 different email address if 10 records based on the email line of the record
Can you make a macro to make multiple pdfs out of websites using an excel list with a column with names for the pdfs and a column of websites?
Possible to save pdf file in the path name on the range
Hi, this looks great! Where can I find the code to cut and paste in Excel macros?
Hi thank you! I think this is something amazing that not many people know about.. it certainly helped me in my tasks. It seems I have forgotten to include the code in the description - I'm surprised no one else has asked. Once I get home today I will go looking for it, put it in the description and ping you.
Thanks for watching and be sure to tell your friends if you it was really helpful!
@@henryouang Perfect, thank you! I thought I was crazy that I couldn't find the coding.
Actually, I have a complicated question. I want to use what you show in the video with an Excel web spreadsheet generated from a Microsoft Form. Is this possible?
So Awesome, Henry!! Thanks a ton. I'm a novice and you made this soooo easy. Only thing I'm having trouble with is saving the pdf's to a network (MS Sharepoint) file path that start out . Can this be done? Thanks!
Hi there, when i try this 2 pdfs are getting exported. first page with our layout and second with no records.
I want to add different pictures at different PDFs. is it possible ???
Hello, i have a question, would it be possible if printing all records into one pdf (each page is a record)?
would be greater even!
thanks for this so much!
THANKS!! REALLY HELPFUL!!
When I heard VBA …I got scared. But I followed through lol. I am going to test on my side. My data is not in a simple list but in a template form that is similar
Thank you so much!
Hello how would I make a macro that prints based on a certain field, for example I have a field with dates and I want to make a pdf of all the records done on that specific date, thanks in advance!
you would have to filter the records before printing
hi Henry, thanks looks great ... can you do this also in Microsoft word?
is it also possible to use this for invoicing (eg with several line items related to one recipient merged in one pdf?
Zsolt
Hi, I believe it can be done in word as well with a ton of customization. The invoice lines can probably be done as well but I haven't spent time thinking of how to do that yet. You could just do invoice lines in excel perhaps?
After running the macro, dialog box says couldn't create pdf files, how to fix this, tnx tnx a lot
I had about 40 pdfs to create and 4 said the same. No idea why...rest generated perfectly. I see in the code that that is the message that is supposed to pop up when there's an error.
Update: Found the issue. File explorer does not allow special characters in file names - I had a ":" in the generated file name which caused the error...
Thanks for the amazing video, Best solution I saw online.
The link for the code doesn't seem to work, could you add it again ?
Hey, this has been fixed. Sorry about that!
Thank you!
Really helpful!! Thank you
sangat membantu,terima kasih
The link does not work - please post link
This has been fixed - sorry about that!
You are awesome
Nice!! :)
Thanks
PASTE THE CODE IN THE DESCRIPTION OR PIN IN THE COMMENT ** LISK IS NO MORE WORKING **