引用:
作者: 美好的今天
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