Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets("sheet1").Copy
Sheets("sheet1").Copy
This line of code copies the sheet1 to a new workbook useing the default template. Is there a way to put into the code and tell excel which template to use. I want to avoid changing everyone default template. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheets("Sheet1").Cells.ClearContents | Excel Discussion (Misc queries) | |||
Sheets("Sheet1").Move After:=Sheets(2) | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Sheets("sheet1").Range command between workbooks | Excel Programming | |||
Sheet1 object not Worksheets("Sheet1") | Excel Programming |