Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I created an XLA add-in called say myStuff.XLA.
I wanted to use most of the myStuff modules, and ThisWorkBook code in a new xla add-in. I copied myStuff.xla to myNewStuff.xla. I clicked on Tools-Add-Ins-Browse and clicked on the myNewStuff.xla. The Add-Ins available Box showed the old name myStuff.xla. I brought up myNewStuff.xla in the Excel Visual Basic page and changed the name in the Project Properties window to myNewStuff. I changed the Form to a new Form name and changed the form label and text boxes to accommodate the new project. Everything compiled ok and was saved. I unchecked the Add-Ins Box and closed Excel. When I brought up Excel and went to Tools-Add-Ins-Browse and clicked on myNewStuff.xla, Excel showed the old name myStuff xla line in the Add-Ins available box instead of the new name myNewStuff. I did a hex editor search on myNewStuff.xla and the name myStuff is still in the xla along with the old form name and some old module names that were deleted or changed in myNewStuff.xla. What did I do wrong? How can I get the myNewStuff line to appear in the Add-Ins available box? What is the proper way to import old xla project code into a new project xla? Btw I didn't see any menu items in the Excel VBA to create new xla projects. Where is that menu item? Thanks for any help you can give me. Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create invoices | New Users to Excel | |||
Create invoices from excel workbook | Excel Worksheet Functions | |||
trying to create | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions |