Save sheet to new file exclude other worksheets

[johnaregan]

Hi
I have an excel file with 2 worksheet, the 1st is updated with info based on a database, I have managed to copy just the data to the 2nd sheet leaving out any formulas etc.
Now I want to be able to save JUST the 2nd sorksheet to a new file. Any suggestions?

Thanks in advance
John

 

[xlbo]

Surprisingly enough, this line of code copies a worksheet and places it in a new workbook

Sheets("Sheetname&quot.copy

'then save to generate a name

activeworkbook.saveas name:="Pathandnamegohere"

HTH Rgds
~Geoff~