printing pdf of 218 closed xls files - (2) ?'s

**jwright650** · 02-24-2011, 11:20 AM

Customer wants me to make pdfs of 218 of my xls files(Ultrasonic Inspection Test reports of weldments). I'm using Adobe Distiller so no problem printing to pdf.

1) Can this be done with VBA without manually opening each and every file and then printing to pdf?

2) If yes, Then
Should I set the security setting so that it doesn't stop_
and ask me to enable macros for each and every file?
End If

**jwright650** · 02-24-2011, 11:51 AM

Found an answer to question #1 online,
Here is a macro written to open closed files (all in one folder) and then print, close, move to the next file....etc...

Please Login or Register  to view this content.

**jwright650** · 02-24-2011, 12:20 PM

Here is the working xls file. This seems to work great. Just set your default printer to your pdf printer.

I haven't tried it with and files that have macros yet....so I will post back when I do and can answer my Question #2.

**jwright650** · 02-25-2011, 02:07 PM

BTW, answer to question #2 is "yes", turn security off and allow it to enable macros...buzzes right along...I broke up the files into 25 per folder because I still had to accept each name that it gave the new pdf file. I got through all 218 in no time, plus 25 more of another report.

**jwright650** · 03-23-2011, 08:37 AM

Was able to get this issue resolved and customer was happy....This thread is "Solved"

**kalpeshvasa** · 06-09-2012, 01:38 PM

Hi ,

I was trying to use this macro to print all excel files as PDF saved in a single folder. The macro stops at "With Application.Filesearch" highlighted in yellow. I am pretty new with macros , can you help?

Regards
Kalpesh

**arlu1201** · 06-09-2012, 02:52 PM

Kalpesh,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.