LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default How do I create a new XLA Add-In from an old one?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create invoices Missie New Users to Excel 6 January 23rd 05 01:05 PM
Create invoices from excel workbook KJH Excel Worksheet Functions 5 December 22nd 04 02:21 PM
trying to create Lost in reconcillation Excel Discussion (Misc queries) 2 December 19th 04 01:05 AM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 01:50 AM
How do I create a total sheet that will pull info from all my she. JulieD Excel Worksheet Functions 2 November 12th 04 08:44 AM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"