copy of file in the same folder path without opening

Hi all,

Requesting help for the vba syntax for below requirements.

I have a file "Report for 22.04.2014" in the folder path "C:\Users\Desktop\open\"

what i am doing currently is opening this file and saveas with current date.

instead since the file size is huge

i would like vba code to make copy of this file and rename File with current date ( without opening ).
So this should save some time in opening the file.

Thanks for the reply.

i am getting
Run time error '90'
Permission denied

any idea why am i getting this

Hi Joakim N,

I have fixed it myself, the error was due to the file extension. The file i had is .xlsm but i was executing the code for .xlsx
That created the Runtime error.

Thanks for your help . Have added stars for you