Creating a new excel file programatically

[Chimanrao]

I am writing a plugin with which , when the user clicks a button, I
want to save the active sheet in a new excel file.

How do I create a new excel file programatically?
howo do I add a existing sheet to this file?

Regards
Chimanrao

 

[Nigel]

In the simplest form use.......

ActiveWorkbook.SaveAs Filename:="C:\Copy of Book.xls"

Sheets.Add

 

[Chimanrao]

I want to save only the active worksheet...

regards
Chimanrao

 

[Rowan]

Try:

Sub newbook()
ActiveSheet.Copy
ActiveWorkbook.SaveAs "c:\Temp\MyNewBook.xls"
End Sub

Hope this helps
Rowan

 

[Nigel]

Sheets("Sheet1").Select
Sheets("Sheet1").Copy
Sheets.Add
ActiveWorkbook.SaveAs Filename:="C:\new book.xls"