I am struggling to SAVE AS excel file with new name including current date.
In my case: Read and Write won’t work, AS read activity not reading formula of excel because excel having 20 sheets.
Copy file giving me error,
Remove file not working as it is removing previous file.
Help me if anyone knows how to save as formula based big excel.
@pari_patel - Have you tried copy file activity
From → Your existing file
To → New file name with Date…
I tried, It is giving me error …
File is used by another process
So you are trying to create another file when the file is open??
No @prasath17
I am only executing copy file activity. No other process is include in my test workflow.
Please show us the error and also show us how your code looks like??
I just tried the below code and when the file is open…
My.Computer.FileSystem.CopyFile("C:\Users\giris\Documents\UiPath\Misc\Codes.xlsx", "C:\Users\giris\Documents\UiPath\Misc\Codes"+now.tostring("MM_dd_yyyy")+".xlsx")
My Output
Hope this helps…
1 Like
Working. Thanks @prasath17
1 Like
@pari_patel - Great…Once you are done with your testing…Please mark my post as solution that will benefit others…
1 Like
@prasath17 I did it. It really helps me. Thank You
I have other query on excel. I posted it, if you have a time please look for it, I need urgent solution,
https://forum.uipath.com/t/urgent-excel-deselect-data-from-filter-and-then-remove-rows/339762
pari_patel:
I did it.
Nope…You liked it…not marked as solution…Please check this post on how to mark the post as solution…
Forum FAQ - How to mark a post as a solution
This document is part of our beginners guide .
This article will teach you how to properly mark a post as a solution.
We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them.
When is the topic resolved?
The topic can be considered resolved when the topic author has fo…
system
(system)
Closed
August 27, 2021, 5:03pm
11
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.