Hi, I’m trying to rename my Excel Workbook (not a sheet but the entire excel file) without opening it and performing it manually (click on the save as button, inserting the path and the name…) but I really don’t find the way to do it. I’ve searched on forum but I only see posts to rename a sheet, to change the format, to create a new workbook…but anything to rename the current excel file.
I need to rename it with a variable name (my variable is a string that changes the project code, example: M1212060-START, R34469734-START or C2064997-START).
I’ve tried using the “Output” option on the excel application scope but it indicates that I can’t convert from string to object or something like this.
Okey! I was focused trying to find a kind of “Save as” activity for excel, I don’t thinked about this option!! Thank you very much @supermanPunch and thanks for the fast answer!!! I will try it immediatelly!
I’m testing it, finally I’ve taked the “Copy file” activity and it seems it must work fine but, I’m not sure why (I must be doing something wrong) it indicates me that it don’t finds the “from” file. It’s strange because I have an excel application scope just before that is finding it without any issue, the path is: "C:\temp\ToUploadDocsToAgresso" + OriginalExcelName
@Airun But the Filename doesn’t have extension according to the error, Can you cross check it ?
Also keep a Backup of the File before using it, and you can do the operation using Move file Activity, No need of Copy File if.you just want to rename
The filename should have the extension .xlsx at the end
Anil_G
Sekoleyte
prashant1603765
adi.mehare
ashokkarale
Darshan_Sable
V_Roboto_V
Achiranga
mively
Logesh_Velu