Macro using PDFCreator works on reboot but then hangs on subsequent runs

Meggs

New member
Joined
May 15, 2013
Messages
1
Reaction score
0
Points
0
Location
Melbourne
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
 
Back
Top