Greetings,
I am using the following code to save a workbook (xlsm) to another workbook (xlsm) with the following code. However, I am needing to save the workbook (xlsm) to another workbook with xlsx. I tried modifying the code by changing the xlsm to xlsx and it does not work.
Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
SaveCopyAs will not allow you to change the file format.
You would need to use the SaveAs method and specifying the new file format type. Depending on how the reset of the code is using the newly named file you may need to create a copy first and then open/saveas
AlphaFrog,
Works perfect. However, because I have Named Ranges on the original workbook, when i open the new workbook, it wants to reference the data with data links.
Can the formulas in the copied workbook be converted to values before saving?
AlphaFrog,
I apologize for the late response - I have traveling without access to the internet.
I don't believe the formulas can be converted to values. I've been trying to figure a way to break the links with the new workbook.
Simplest thing would be to use the copyas routine I suggested. That was all linkage will automatically update.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks