Facing issue while trying to perform Save As action on an excel sheet using Uipath

Question

Hello, I am trying to Save an Excel File to a different format using UI Path. The workflow works fine, it opens the Save As window, inputs the filename, it selects the file format in the dropdown list and then it clicks the save button. However the file format does not change. This is the bit of the flow in question:

At the end of that bit of the workflow, it save the file with the new name, but it’s not in CSV.

Please help

Answer 1

Hello there, a work around that I found in Excel is building a workflow like this:

• Excel Application Scope;

• Click “File” ;

• Click “Export” ;

• Click “Change File Type” ;

• Double Click on the desired file format ;

• A “Save As” Window will appear, with you chosen format already selected. In this widow you can write the desired File Name / Path and it will save it correctly.

Hope this works.