Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a new worksheet from a template using VBA
Hi,
I am having a problem creating a worksheet from a template using a click-button. Private Sub cmdNewWorksheet_Click() Worksheets.Add Befo=Worksheets("Finish") Worksheets(Worksheets.Count - 1).Name = txtNewWorksheet.Text txtNewWorksheet.Text = "" End Sub I have a template set up, template1.xlt, with a worksheet created in this called template. Does anyone have any ideas? Any help will be much appreciated. Thank you in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a new worksheet from a template using VBA
You can just use
Sheets.Add Type:= "C:\myTemplate.xlt" Before seems to fail with this option, but you could move it afterwards. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "David Coyle" <David wrote in message ... Hi, I am having a problem creating a worksheet from a template using a click-button. Private Sub cmdNewWorksheet_Click() Worksheets.Add Befo=Worksheets("Finish") Worksheets(Worksheets.Count - 1).Name = txtNewWorksheet.Text txtNewWorksheet.Text = "" End Sub I have a template set up, template1.xlt, with a worksheet created in this called template. Does anyone have any ideas? Any help will be much appreciated. Thank you in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a new worksheet from a template using VBA
Thanks!
for some reason, the code worked when i removed the 'work' from 'worksheets' Private Sub cmdNewSheet_Click() Sheets.Add Befo=Sheets("Finish"), Type:="C:\template1.xlt" Sheets(Sheets.Count - 1).Name = txtNewSheet.Text txtNewSheet.Text = "" End Sub Much Appreciated. "Bob Phillips" wrote: You can just use Sheets.Add Type:= "C:\myTemplate.xlt" Before seems to fail with this option, but you could move it afterwards. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "David Coyle" <David wrote in message ... Hi, I am having a problem creating a worksheet from a template using a click-button. Private Sub cmdNewWorksheet_Click() Worksheets.Add Befo=Worksheets("Finish") Worksheets(Worksheets.Count - 1).Name = txtNewWorksheet.Text txtNewWorksheet.Text = "" End Sub I have a template set up, template1.xlt, with a worksheet created in this called template. Does anyone have any ideas? Any help will be much appreciated. Thank you in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a new worksheet from a template using VBA
Odd, I tried that and it didn't for me?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "David Coyle" wrote in message ... Thanks! for some reason, the code worked when i removed the 'work' from 'worksheets' Private Sub cmdNewSheet_Click() Sheets.Add Befo=Sheets("Finish"), Type:="C:\template1.xlt" Sheets(Sheets.Count - 1).Name = txtNewSheet.Text txtNewSheet.Text = "" End Sub Much Appreciated. "Bob Phillips" wrote: You can just use Sheets.Add Type:= "C:\myTemplate.xlt" Before seems to fail with this option, but you could move it afterwards. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "David Coyle" <David wrote in message ... Hi, I am having a problem creating a worksheet from a template using a click-button. Private Sub cmdNewWorksheet_Click() Worksheets.Add Befo=Worksheets("Finish") Worksheets(Worksheets.Count - 1).Name = txtNewWorksheet.Text txtNewWorksheet.Text = "" End Sub I have a template set up, template1.xlt, with a worksheet created in this called template. Does anyone have any ideas? Any help will be much appreciated. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
Creating a worksheet/template for Mileage | Excel Worksheet Functions | |||
Creating summary worksheet from template | New Users to Excel | |||
creating template | Excel Programming | |||
Creating a new worksheet from a template | Excel Discussion (Misc queries) |