Question

2
Replies
44
Views
JonathanB1027 Member since 2018 14 posts
Avanade
Posted: April 27, 2020
Last activity: June 12, 2020

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****

Pega Robotic Process Automation 8.0 SP1 Robotic Process Automation
Share this page LinkedIn