Excel add-ins not recognized by VB5

Excel add-ins not recognized by VB5

Post by LLoyd Mund » Mon, 05 Oct 1998 04:00:00

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)


1. Recognizing functions in Add-Ins

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 screw up; so why doesn't it

 Steve Baker                        

 Field Training                     Fidonet: 1:300/10.4

2. Useful MSDOS Programs at SIMTEL20 and Garbo (Part 2 of 2)

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

4. Outlook Express 6 - won't remember my password

5. Using MS Excel 4 add-ins with Excel 5.0a...

6. testing special keys

7. ADV: OMDI Excel add-ins now downloadable

8. Voicemail Light Authrization Codes

9. Excel add-ins intruding into Publisher

10. Excel Add-Ins?

11. How to convert Excel 95 add-ins back to .xls

12. can arrow add-ins be used in Excel 4.0