| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Templates in Add-in
Hello,
I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
thisworkbook.Worksheets(1).Range("A1").Value
-- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
Tom,
The command does not work (doesn't do anything, not even an error) but maybe I wasn't clear enough. My Add-in had 2 sheets called test1 and test2. The Add-in is not opened but just "loaded" through Tools / Add-ins .... Once loaded the Add-in creates a menu. I'd like to be able to create automatically a new workbook with a new sheet based on (copied from) test1 or test2 from the loaded Add-in. Thank you again. Eric "Tom Ogilvy" wrote in message ... thisworkbook.Worksheets(1).Range("A1").Value -- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
Sheet1.Copy
or Sheets("Sheet1").Copy -- HTH... Jim Thomlinson "Eric" wrote: Tom, The command does not work (doesn't do anything, not even an error) but maybe I wasn't clear enough. My Add-in had 2 sheets called test1 and test2. The Add-in is not opened but just "loaded" through Tools / Add-ins .... Once loaded the Add-in creates a menu. I'd like to be able to create automatically a new workbook with a new sheet based on (copied from) test1 or test2 from the loaded Add-in. Thank you again. Eric "Tom Ogilvy" wrote in message ... thisworkbook.Worksheets(1).Range("A1").Value -- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
Sorry but this does not work either. The sheet I want to copy is in the
Add-in but is not apparent.. Thank you. Eric "Jim Thomlinson" wrote in message ... Sheet1.Copy or Sheets("Sheet1").Copy -- HTH... Jim Thomlinson "Eric" wrote: Tom, The command does not work (doesn't do anything, not even an error) but maybe I wasn't clear enough. My Add-in had 2 sheets called test1 and test2. The Add-in is not opened but just "loaded" through Tools / Add-ins .... Once loaded the Add-in creates a menu. I'd like to be able to create automatically a new workbook with a new sheet based on (copied from) test1 or test2 from the loaded Add-in. Thank you again. Eric "Tom Ogilvy" wrote in message ... thisworkbook.Worksheets(1).Range("A1").Value -- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
Have you made the sheet in the addin hidden (which is not necessary since the
sheets in an addin are not visible by virtue of being an addin? That being the case... Sheet1.Visible = xlSheetVisible Sheet1.Copy -- HTH... Jim Thomlinson "Eric" wrote: Sorry but this does not work either. The sheet I want to copy is in the Add-in but is not apparent.. Thank you. Eric "Jim Thomlinson" wrote in message ... Sheet1.Copy or Sheets("Sheet1").Copy -- HTH... Jim Thomlinson "Eric" wrote: Tom, The command does not work (doesn't do anything, not even an error) but maybe I wasn't clear enough. My Add-in had 2 sheets called test1 and test2. The Add-in is not opened but just "loaded" through Tools / Add-ins .... Once loaded the Add-in creates a menu. I'd like to be able to create automatically a new workbook with a new sheet based on (copied from) test1 or test2 from the loaded Add-in. Thank you again. Eric "Tom Ogilvy" wrote in message ... thisworkbook.Worksheets(1).Range("A1").Value -- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Templates in Add-in
Eric
Try this............ Workbooks("myaddin.xla").Sheets("Sheet1").Copy Gord Dibben MS Excel MVP On Wed, 21 Feb 2007 16:58:40 -0500, "Eric" wrote: Sorry but this does not work either. The sheet I want to copy is in the Add-in but is not apparent.. Thank you. Eric "Jim Thomlinson" wrote in message ... Sheet1.Copy or Sheets("Sheet1").Copy -- HTH... Jim Thomlinson "Eric" wrote: Tom, The command does not work (doesn't do anything, not even an error) but maybe I wasn't clear enough. My Add-in had 2 sheets called test1 and test2. The Add-in is not opened but just "loaded" through Tools / Add-ins .... Once loaded the Add-in creates a menu. I'd like to be able to create automatically a new workbook with a new sheet based on (copied from) test1 or test2 from the loaded Add-in. Thank you again. Eric "Tom Ogilvy" wrote in message ... thisworkbook.Worksheets(1).Range("A1").Value -- Regards, Tom Ogilvy "Eric" wrote: Hello, I am learning VBA and I just created several templates/forms (sheets) that I saved into an Add-in. The Add-in creates automatically a menu item and I would like to be able to call the templates (sheets) saved in the Add-in from this menu. How can I do that? What would be the command to execute? Thank you. Eric . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saved templates opening as templates | Excel Discussion (Misc queries) | |||
| Templates | Excel Discussion (Misc queries) | |||
| templates | New Users to Excel | |||
| Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
![Eric[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
