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.
Use Copy File Activity from Source and Destination
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)
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.