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.