Struggling with macro to rename file using current date

Hello all,

You have been so helpful in the past and my appreciation to all. I'm having some difficulty renaming an exising .csv file with the current system time stamp and changing it to a .xls file. I have this snippet of code that doesn't seem to be working properly:

Please Login or Register  to view this content.

When I add this to the module the () after Date dissapear and I get a yellow warning highlight. I'm not really sure why.

I plan on moving this renamed file using the following code:

Please Login or Register  to view this content.

Any ideas? So in review, I need to rename a file to the current system time then move it to an existing subdirectory called "Archive" in the same directory. At some point I would like to repeat this renaming and moving 4 times (4 files). How should I build a loop to do this?

Hi,

Think you only need to drop () and replace
Date()
by
Date

Glad it fixed your problem ...