| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new excel file programatically
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a new excel file programatically
In the simplest form use.......
ActiveWorkbook.SaveAs Filename:="C:\Copy of Book.xls" Sheets.Add -- Cheers Nigel "Chimanrao" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a new excel file programatically
I want to save only the active worksheet...
regards Chimanrao |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a new excel file programatically
Try:
Sub newbook() ActiveSheet.Copy ActiveWorkbook.SaveAs "c:\Temp\MyNewBook.xls" End Sub Hope this helps Rowan Chimanrao wrote: I want to save only the active worksheet... regards Chimanrao |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a new excel file programatically
Sheets("Sheet1").Select
Sheets("Sheet1").Copy Sheets.Add ActiveWorkbook.SaveAs Filename:="C:\new book.xls" -- Cheers Nigel "Chimanrao" wrote in message oups.com... I want to save only the active worksheet... regards Chimanrao |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| programatically creating dialog box | Excel Programming | |||
| Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) | |||
| Programatically Creating a Hyperlink Using VB.Net ? | Excel Programming | |||
| Creating a hyperlink in a excel cell programatically | Excel Programming | |||
| Programatically saving an excel .csv file to .xls file... | Excel Programming | |||
Linear Mode
