How to copy an Excel sheet in xlsm to create a new book

I am currently trying to copy and paste an xlsm sheet with the Copy Sheet activity and create a new book with it.

However, since the source is an xlsm file, I tried to output the destination as an xlsm file, but I got an error “This extension is not available for the selected file format”.

When I tried to output the destination as xlsx, the copied sheet was output as a new book without any problem.

However, I would like to output as an xlsm file if possible.

【Here’s what I’ve done】
1、Once output as an xlsx file, change the file extension with the move file activity. As a result, I got an xlsm file, but when I tried to open it, I got a file corruption error saying “Wrong extension” and could not open it.
I am not familiar with VBA and code, so I am currently investigating how to use and write.

So, if there is any better way to do this, please let me know.
Thank you for reading.

that’s the macro extension of your Excel Application, you can enable it to use macros

Below link shows how to enable it

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.