Excel Data To Multiple PDFs (No PowerApps Premium, Free!) - Part 2/2

[@J0hn1o1o]

Thank you for this two-part series! You explained every aspect and supplied free code! Amazing!

[@MultiAilove]

BRILLIANT!!! Thank you so much! You are STAR!!

[@zahirarahvenia5738]

You absolutely help my task Henry, thank you so much

[@Alexander-do2wp]

AMAZING!!! I finally got an long term issue solved thanks to you!

[@SS-zi3ky]

Never used these items in Excel - super helpful!

[@samsonadeyanju9194]

Thank you for helping and making it easy and straightforward

[@thipsawat2507]

This’s so helpful. Thank you million times for doing such a good clip!!

[@financetips]

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

[@Cryptorich1670]

What if there is a dropdown list on the print area and data changes based on dropdown list

[@ArmenioRodriguesAndrade]

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?

[@janekosasih6865]

THANKS!! REALLY HELPFUL!!

[@EL-Beth-EL]

Hi there, when i try this 2 pdfs are getting exported. first page with our layout and second with no records.

[@pauldippenaar658]

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

[@radhansaati8929]

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!

[@katieehrlich3795]

Hi, this looks great! Where can I find the code to cut and paste in Excel macros?

[@henryouang]

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!

[@katieehrlich3795]

@@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?

[@kiranarana7274]

Possible to save pdf file in the path name on the range

[@ChadFuller-y5s]

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!

[@irfanb4332]

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?

[@GauravChauhandgi]

I want to add different pictures at different PDFs. is it possible ???

[@AnastasiaVlasova-gd1pd]

Thank you so much!

[@financetips]

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

[@anerbehlic2899]

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!

[@radhansaati8929]

you would have to filter the records before printing

[@jeffreyhibbard369]

Thank you!

[@IanPreddy]

Really helpful!! Thank you

[@nazrahjamaludin9534]

sangat membantu,terima kasih

[@zsoltudvari755]

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

[@henryouang]

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?

[@bhongsaivuding47]

After running the macro, dialog box says couldn't create pdf files, how to fix this, tnx tnx a lot

[@rasmusjensen4186]

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...

[@aaryachoukhany5173]

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 ?

[@henryouang]

Hey, this has been fixed. Sorry about that!

[@communicationatoz]

You are awesome

[@ahmednoushadgijoni3178]

Thanks

[@SS-zi3ky]

Nice!! :)

[@RalphCarras]

The link does not work - please post link

[@henryouang]

This has been fixed - sorry about that!

[@krutanandaacharya5925]

PASTE THE CODE IN THE DESCRIPTION OR PIN IN THE COMMENT ** LISK IS NO MORE WORKING **