Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 417
Default 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
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
requirement for creating a sub menu in c# excel addin shantanu Excel Programming 2 May 2nd 07 09:37 AM
#REF when creating an Addin stewdizzle Excel Discussion (Misc queries) 1 January 4th 07 06:07 AM
Creating Excel Addin salooha Excel Programming 6 June 28th 05 04:44 PM
Problems creating a dll in Excel 2003 using addin designer Tammy[_5_] Excel Programming 1 October 22nd 04 05:20 AM
Creating a new Excel Addin Michael Lawrence Jr. Excel Programming 1 December 17th 03 10:30 PM


All times are GMT +1. The time now is 07:32 PM.

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

About Us

"It's about Microsoft Excel"