I would like to modify the below so that the contents of cell D2 of the current file becomes the file name.
Thanks for any help
Phil
![]()
Please Login or Register to view this content.
I would like to modify the below so that the contents of cell D2 of the current file becomes the file name.
Thanks for any help
Phil
![]()
Please Login or Register to view this content.
Last edited by davesexcel; 12-11-2008 at 08:15 AM. Reason: No Code Tags
Please read the forum rules, code tags are required when displaying VBA code.
This code shows how to save a workbook with Range C1 as the name
![]()
Please Login or Register to view this content.
Last edited by davesexcel; 12-11-2008 at 08:08 AM.
Try this code
U just need to enter the complete path of the file in D2 and it will save with the name specified in D2![]()
Please Login or Register to view this content.
Last edited by Shijesh Kumar; 12-11-2008 at 08:03 AM.
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks