Posted: 27 Apr 2020 10:57 EDT Last activity: 12 Jun 2020 9:51 EDT
Saving Excel File As New Type
How are you supposed to go about saving Excel files as new file types with Robotics Studio? I have an automation that downloads a .xlsb file, but needs to save it as a .xlsm type so that it can utilize some built in macros.
I have tried using the "SaveAs" method which doesn't work (guessing it's only meant to be used to change the file name and not extension), and i've also tried creating a proxy from the workbook and using it's "_SaveAs" method which allows you to pass in a filetype, password, etc, but it hasn't worked either.
***Edited by Moderator Marissa to update Platform Capability tags****