Can I save the workbook to a certain folder plus saving the same workbook as PDF. The workbook name will be value in cell A1, and the folder would be C:\ExcelSave\. If a workbook has the same name then ask to overwrite it .
Thanks
Can I save the workbook to a certain folder plus saving the same workbook as PDF. The workbook name will be value in cell A1, and the folder would be C:\ExcelSave\. If a workbook has the same name then ask to overwrite it .
Thanks
Last edited by zplugger; 09-14-2017 at 12:23 PM.
What would be the PDF name?
If posting code please use code tags, see here.
Thanks Norie Value of cell A1
Got this to do the pdf ,but how do I add the workbook save as save name?
Please Login or Register to view this content.
This works for me:
Please Login or Register to view this content.
Last edited by kev_; 09-14-2017 at 12:14 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanks Kev_
Works Perfect and so clean and simple, Thank You for taking the time and I hope to learn from it.
Simple is best - less to go wrong!
Thanks for reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks