Using excel application scope and save the file with another filename

Hi All,

Question, I’m Using an excel application scope and do then some write range, write cell, Insert/delete columns,copy paste activities in it. After that I want to save the file, but I don’t want to overwrite the old excel file. I wan’t to save them with another new name. Could someone explain me how I can handle this?

I was thinking with the F12 hotkey and then save as but this is not possible…

Hi @M_L

Steps you must do as below :-

  1. Read the Original Excel using read range activity which will create a datatable variable
  2. Use that data table variable are write the data to new excel using Write range activity
  3. Then do Whatever changes you want on the new file

Hope this may help you to solve your issue
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

hi @M_L,

Here is an activity called “Copy to file”. It will copy the sheet one file to another file.

In this case video I have used this activity.

Thank you
Balamurugan.S

1 Like

Thnx mate!

Thnx

Hi @M_L

Cheers
You are welcome

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.