Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help creating an Excel AddIn
Need to get an Excel AddIn compiled for my son so he can support his thesis.
I can get it to compile in VB 2005 Express, but I cannot get it to generate a .xla file, I just get a binary (dll?) formatted file and a blank setup script. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help creating an Excel AddIn
Is the code in a *.VBA file (VBA extension)?
1. Start up Excel. 2. Create a new workbook. 3. Go into the VBA editor. 4. Import the VBA code from the file. 5. Compile the code and exit the VBA editor. 6. Back in Excel, use File|Properties to enter a Title and Comment (these will show up in the add-ins dialog box during installation of the add-in). 7. Save the workbook as a Microsoft Excel Add-In (listed at the bottom of the "Save as type" drop-down field). -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
requirement for creating a sub menu in c# excel addin | Excel Programming | |||
#REF when creating an Addin | Excel Discussion (Misc queries) | |||
Creating Excel Addin | Excel Programming | |||
Problems creating a dll in Excel 2003 using addin designer | Excel Programming | |||
Creating a new Excel Addin | Excel Programming |