LinkBack URL
About LinkBacks
Hi,
I have a xlsm file which I need to save as an xlsx file with the same name, in the same folder and over write any existing file (Which may exist due to previous use).
Thanks in Advance
Hi,
I have a xlsm file which I need to save as an xlsx file with the same name, in the same folder and over write any existing file (Which may exist due to previous use).
Thanks in Advance
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
or you could just use save-as, and select xlsx from the drop-dpwn save-as list, and just overright whatever file may or may not be there?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks shg that works. I also need the code to close the .xlsx file and re-open the .xlsm file, can you add that? Thanks
Last edited by ccpsc; 05-05-2012 at 10:06 PM.
I got it to work, not sure if it is good code but it does the job
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks