How to Save and SaveAs the Excel File

Help StudioX
,
1

Hi ,

I wanted to do below two operation in excel file - StudioX.
1.Save
2.SaveAs

2

Working with excel will require you to use an excel card which by default saves after each operation.
Then in the end, since we don’t have yet an activity to “save as” you can simply use “copy file” activity and use for output your desired name, as workaround.
So:
1.excel card pointing to an excel file
2.do your work on it
3.add “copy file” activity to copy your excel file to a desired new file name.

3

Hi Saransr, you may find the save as answer here:

1 Like
4

If you’re trying to watch this video and aren’t able to follow the steps, it’s because he is using Studio (not StudioX). Please reference the steps below for how to trigger a Save As command using a Send Hotkey function in StudioX.

First off…yes, you can send a Hotkey function in Excel, but you have to do it as multiple different actions (Use Excel & Use Application). You need to either embed the Use Application inside the Use Excel or have it run after the Use Excel. Also, you need to reference the specific Excel window name (usually the file name) under ‘Application arguments’ when using the Use Application (not required when embedding function, but is required when running after Use Excel completes).
*When not embedding Use Application, remember to set the Use Application ‘Close’ property to “Never” or it will close the Excel window before you’re finished using it.
See below for screenshot of my bot to mirror.

Excel Save As Bot
Excel Save As Bot1620×1118 303 KB

I hope this helps provide you a solution.
DerRoc
If your going to bot it, make sure you D’Roc it!