I created a macro that opens 4 workbooks (named Qtr 1, Qtr 2, Qtr 3, Qtr 4) from a larger workbook with 8 sheets.
I run code in each book and then I would like to close and save each one but I can't get that part to work. for the people who share the file with me.
I can only figure out how to save it to my desktop but not save to the desktop of others.
Can anyone help?
Thanks,
I run code in each book and then I would like to close and save each one but I can't get that part to work. for the people who share the file with me.
I can only figure out how to save it to my desktop but not save to the desktop of others.
Can anyone help?
Thanks,