How to copy excel file and change the file name?

Help Activities
, , ,
1

Hello,

I’d like to make below process. Could you please help for this?

  1. If there is no current date file, copy last month file.
  2. Change the file name to yyyy-MM(This month)
  3. Save

image

image
image1178×616 20 KB

image
image1314×335 15.8 KB

Directory.GetFiles(“D:\Users\01048398\Desktop\Treasury_CashReport_Final”,““+Today.ToString(“yyyy-MM”)+”.xlsx”)

2

You can use a copy file/move file activity and your desired file name. Don’t forget to include the file extension.

3

@kenneth.m Thank you for your comment.
I’ve tried to rename the target file with Move File activity but faced below error message.
which script should I change ?

image
image1248×516 24 KB

4

Hi @Dorothy_lee

Please refer the below link.

5

Hello~
Could you please review which part is wrong?
FileSystem.Rename(“D:\Users\01048398\Desktop\Treasury_CashReport_Final\template”,“D:\Users\01048398\Desktop\Treasury_CashReport_Final\Today.ToString(“yyyy-MM”)”)
image

6

Hi @Dorothy_lee

Please mention the file name in existing path details. I have attached screenshot for your reference.

image
image835×523 8.97 KB

Happy Learning :slightly_smiling_face:

7

It should be coded like this. FileSystem.Rename(“D:\Users\01048398\Desktop\Treasury_CashReport_Final\template”,“D:\Users\01048398\Desktop\Treasury_CashReport_Final\" + now.ToString("yyyy-MM"))

You can see no error in the invoke code

image

Please add the proper file extension of your file name…Please see the example below…

FileSystem.Rename(“C:\Users\giris\Desktop\text.txt”,“C:\Users\giris\Desktop\text-" + now.ToString("yyyy-MM") + ".txt")

My Output
image

8

hi @Dorothy_lee,

Please separate the Today.ToString from the file path (i.e. “D:\Users\kenneth\Desktop\Folder Name\”+Today.ToString(“yyyy-MM”)+“.xlsx”

9

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