How to export from xlsm file to xls but original file must stay in xlsm(vba script)

Hello,

Please,

I have example file with macro support.

"original.xlsm"

I will do some changes.

I need save these changes to "original.xlsm" with macro support. And to "original1.xls" without macro support (VBA totally disabled).

The "original.xlsm" must be ready with macro for another work.

*******************
Whole process must be performed like VBA script.

Thank you in advance.

Best Regards
Martin

Thank you a lot!

I try it.

Please , can you create it as test file for path:

Names as you want (test.xlsm and test1.xlsx)

C:\test\

Because If I try create the file maybe is problem with local language localization. But I use you file it will works.
Thank you a lot.

Martin

Thank you very much,

I added button to this script. And the file was uploaded.

Problem is that it does not work. If I try it so it does nothink.

The screen is opened again but file .xlsx did not created.

Thank you,

Martin

I am sorry, it works!!

Thank you a lot. The file was created in "documents" folder of user.

I try to perform that file will be created at path as original file.

Please can you try to define the path?

.xlsx file to: "c:\delete\

Thank you a lot!

It works!

This thread can be marked as solved

Great job!

Regards.

Martin