Auto Saving File to Folder with Current Date

Hi,

I have learnt how to auto create a folder named with the current date. Now, I would like my macro to save it to the folder i have just created, that is numbered with current date. Can anyone let me know how this can be achieved ? Thank you.

Regards,
Jeffrey

Hello Jeffery,

It is hard to answer an incomplete question. Please proof read your posts before posting them. You need to include what type of file you want to save to this new folder e.g. xls, csv, txt, etc. This impacts what code will be used to save the file.

Sincerely,
Leith Ross

Hi,

Thanks. I would like to save my file as a .csv and here is my code for the macro. Do i need to alter my date format so it reads the yymmdd, in that way, the macro which is to be written will choose the highest value or is there any other way ? thanks

Please Login or Register  to view this content.