M_L
July 2, 2020, 3:03pm
1
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 :-
Read the Original Excel using read range activity which will create a datatable variable
Use that data table variable are write the data to new excel using Write range activity
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
Happy Automation
Best Regards
Er Pratik Wavhal
1 Like
balupad14
(Balamurugan)
July 2, 2020, 3:29pm
3
hi @M_L ,
Here is an activity called “Copy to file”. It will copy the sheet one file to another file.
Hi Friends,
I have included the below new custom components in the package.
1.Create Workbook.(Create a new worksheet)
2.Copy to File (Copy the worksheet to another excel file).
3.Copy to WorkBook (Copy the worksheet inside the workbook).
4.HideUnhide the worksheet
5.Protect Unprotect the worksheet
[image]
Create WorkBook
Properties
[image]
Sample : CreateWorkbook.zip (18.5 KB)
Copy To File
This activity copies the work sheet to an another excel file. If the another file is not ex…
In this case video I have used this activity.
Thank you
Balamurugan.S
2 Likes
Hi @M_L
Cheers
You are welcome
Happy Automation
Best Regards
Er Pratik Wavhal
1 Like
system
(system)
Closed
July 5, 2020, 7:37pm
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.