How to copy an active Excel worksheet to another excel file?

[derricklo1980]

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!

 

[SkipVought]

hi,

In Excel, NOT VBA, you right-click the sheet you want to copy, and select Move or Copy... and follow the bouncing ball.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[derricklo1980]

Hi, I want to automate and do it in VBA/macro. Also I want to copy to a new file. Any idea?

 

[SkipVought]

Turn on your macro recorder.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]