Adding the dynamic path for excel for writing into the cell

Help
1

Hi friends,
I am using write cell activity for writing some variable into the cell. For choosing the excel to write cell, I am using variable “Path” in the file path for the excel (as highlighted in image ).
‘Path’ variable is used to create the copy of an existing excel and rename it with current date. Now to open newly created excel, I am using the same variable, however instead of opening the excel with the indicated path, the bot is creating new excel with no name and writing into that.Automation

2

Hi @rj14

Use Copy File Activity from Source and Destination

Thanks
Ashwin S

1 Like
3

Yes… I have used this activity for creating new excel and renaming it.

So bot should first create the excel (Using the copy activity-this part is working) and the open this newly created excel and write into it with specified cell, for which I am using variable to access the file path (so instead here the bot creates altogether new excel)

4

Hi @rj14

Ensure that newly created file has written the values to the cell

Based on that you can open the excel by using excel application scope or start application

Thanks
Ashwin S

5

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