Excel 2007 Macro Question
 

I wan to create a macro to print PDF with the file name filled automatically. What I tried is to record
record the copy a text in a cell
past into the "file name" when you print PDF file
stop recording.

Unfortunately, it is not working as what I intended. Any idea?

Thanks

Google search "excel macro print to pdf".

Thanks for your hint. I browsed those post and seem there was no the solution. But I found the following description which is exactly what I wanted.

"The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I obviously want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter."

I am not IT guy, I only can do the macro with recording. I am stucking at copy the cell content to the file name.

Thank you