Printing Worksheets To A PDF File (Using Early Binding)
Print Specified Worksheets to a Single PDF File
G'Day, I am using the above code. It worked a treat the first time (and after only on reboot / ctrl break) as it keeps hanging for some reason. The code lines are usually DoEvents or Set pdfjob = Nothing.
The aim is to deliver individual reports from a master excel spreadsheet. Once it works I am going to copy the code and make 7 different modules (each one generating a bespoke pdf report using buttons to invoke the macros).
Got excited when it worked at first but now just frustrated.
Any help or ideas would be much appreciated.
PS: Lastly if anyone knows how to use VBA to insert bookmarks into these PDFs that too would be appreciated.
Cheers,
Meggs
Print Specified Worksheets to a Single PDF File
G'Day, I am using the above code. It worked a treat the first time (and after only on reboot / ctrl break) as it keeps hanging for some reason. The code lines are usually DoEvents or Set pdfjob = Nothing.
The aim is to deliver individual reports from a master excel spreadsheet. Once it works I am going to copy the code and make 7 different modules (each one generating a bespoke pdf report using buttons to invoke the macros).
Got excited when it worked at first but now just frustrated.
Any help or ideas would be much appreciated.
PS: Lastly if anyone knows how to use VBA to insert bookmarks into these PDFs that too would be appreciated.
Cheers,
Meggs