PDA

View Full Version : How to copy an active Excel worksheet to another excel file?



amitash
10-01-2012, 09:10 AM
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!

Simon Lloyd
10-01-2012, 05:37 PM
Have you any code so far?, have you tried using the macro recorder to try and accomplish some of this?