LoopRange including save to PDF

Hi there,

Some time ago someone on this site helped me with the below macro. However I now want to adapt it further and was hoping someone might be able to offer some more assistance. I'll explain below the code.

Please Login or Register  to view this content.

At present this takes a unique reference from column A in one sheet, pastes it in to another sheet which activates a number of VLOOKUPs to make a unique form, and then prints it out, then repeats.

What I would ideally like to do now is instead of printing, make it save each unique form as a PDF in a specific folder, with a title of each PDF being the unique reference from column A on the first sheet.

If someone thinks this would be possible I'd really appreciate their input!

Hi again,

If anyone had any thoughts on this I'd love to hear them. I've seen similar threads online but the solutions seem to have involved downloading some kind of secondary software to comlete the task, which I'm not able to do at work.

You can remove the filename dialog routine. Set the print range(s) and a routine like this can be used.

Please Login or Register  to view this content.