Recognizing functions in Add-Ins

Recognizing functions in Add-Ins

Post by Steve Bak » Wed, 01 Jun 1994 11:56:27

I am using Excel 5. I have created a simple woorkbook with a function in a
VBA module. When I convert it to an .XLA file (and install it), the function
is _not_ available through Function Wizard, nor is it recognized if I type it
into a cell.

I have followed (and rechecked) the steps for doing this in the Visual Basic
User's Guide on page 277. It looks too simple to*up; so why doesn't it

 Steve Baker                        

 Field Training                     Fidonet: 1:300/10.4


1. Excel add-ins not recognized by VB5

I have an excel workbook that uses an add-in which I downloaded from the
Microsoft site. This excel add-in, called HTML.XLA allows me to create HTML
pages from my Excel spreadsheet data AUTOMATICALLY from within VBA.

 In my code it runs a sub called "ConvertToHTML" and all I have to do is
pass it parameters. It works fine but here's my problem.

I have written a front-end in VB5 and connected to the excel workbook. Thats
all OK except when I try to compile the VB5 project it fails because it does
not recognize the sub named above. In effect, my VB5 project does not
recognize an excel add-in. It complains about it not being the correct type
of object reference. I cannot reference this add-in anywhere within the VB5
environment, and it's not listed in the object browser so my project is
DOOMED until I find a way for VB5 to recognize this excel add-in.

Any help wll be greatly appreciated.


lloyd mundy (from London)

2. Compiling cl.el

3. Using user-defined functions as add-ins?

4. Send isn't recived.

5. Excel 97 - Engineering Functions add-ins

6. Why run Command Prompt from Start differs from running "cmd.exe"?

7. Excel 5 - How to use Add-Ins Analysis functions in VBA

8. Workshop "Soft Computing 96",Kazan,Russia

9. Help with Excel Add-ins and function macros

10. ADV: OMDI Excel add-ins now downloadable

11. Excel: can add-ins be saved within an Excel file?

12. Excel add-ins intruding into Publisher

13. Advice required: Multiple workbooks, User forms, Add-ins?