Scrap
03-15-2005, 01:06 PM
Here is the way to add a worksheet already existing:
-Save your workbook with the sheet. (File; save as...; In the Save as type Combobox, Choose template(*.xlt) _Be sure to remember the path!_
-Use this code:
Sheets.Add Type:="\\your_path_here\template.xlt"
or
Sheets.Add type:="c:\...\template.xlt"
:thumb
-Save your workbook with the sheet. (File; save as...; In the Save as type Combobox, Choose template(*.xlt) _Be sure to remember the path!_
-Use this code:
Sheets.Add Type:="\\your_path_here\template.xlt"
or
Sheets.Add type:="c:\...\template.xlt"
:thumb