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

Help Activities
, ,
1

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 vb.net 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.

2

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
3

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