I think this is probably an easy question and is probably on the board somewhere but this is a bit of an emergency.
I have a macro where I want to copy one Excel file and place the copied file it in a different folder with a different name.
E.g File1.xls copied to File2.xls
The file one is like a template and contains macros that is why I have to copy the whole file because I want to keep those macros in the new file. So I cant just copy the sheet.
Thanks
I have a macro where I want to copy one Excel file and place the copied file it in a different folder with a different name.
E.g File1.xls copied to File2.xls
The file one is like a template and contains macros that is why I have to copy the whole file because I want to keep those macros in the new file. So I cant just copy the sheet.
Thanks