Question
Avanade
US
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****
Pegasystems Inc.
IN
Hi,
I worked on a requirement where I had to save as csv to xlsx format. For this I made use of microsoft excel component which has a save as method where we can pass file name and save as type.
Avanade
US
I've tried that, but it always gives me an error message when i use it - granted, I'm doing a different conversion, xlsb to xlsm - i wonder if it only works effectively on certain file types.