Dec 30th, 2012, 00:28 | #1 |
Member
注册日期: Sep 2008
帖子: 83
|
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 |
|
Dec 31st, 2012, 01:14 | 只看该作者 #3 |
Member
注册日期: Sep 2008
帖子: 83
声望: 0
|
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 |
|