Hi,
I want to copy an active Excel worksheet to another new Excel file, continue to work in the new file (e.g. using Sub codeContinue() which contains the code for work), close the new file, switch back to the original Excel worksheet as the active worksheet. How to do that? Thanks!
Have you any code so far?, have you tried using the macro recorder to try and accomplish some of this?
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote
