The following will save the file as you specify, not sure about the .pdf
format your require, but the message box will be suppressed

Application.DisplayAlerts = False
Workbook.SaveAs Filename:="path\filename"
Application.DisplayAlerts = True

"bstruchen" wrote in message
...
I need to create a macro in excel that prints out multiple reports in
pdf format. Is there a way to hardcode the pdf file name so the save
as message box doen't appear??

Thanks


---
Message posted from http://www.ExcelForum.com/





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---