ferocious12
Member
Hi,
I have to open a file saved on a desktop of the user and copy worksheet 1, close without saving and paste the copied worksheet in the active workbook containing macro.
Can you help me with the macro as user name used as part of the path of file to be opened changes as the macro is used by new user.
Thanks
I have to open a file saved on a desktop of the user and copy worksheet 1, close without saving and paste the copied worksheet in the active workbook containing macro.
Can you help me with the macro as user name used as part of the path of file to be opened changes as the macro is used by new user.
Thanks