add-ins

[Guest]

Hi,

I need help.
I have an add-ins in EXCEL that used to work before but now its not working.
I am using EXCEL 2003 as soon as I load the add-ins I got this message saying.

Microsoft form "Could not load an object because it is not available on this
machine"

What object? is it some kind of a library that's not installed on my machine?

Using Excel 2000 I am getting a different error message and said,

Run-time error '430'
Class does not support Automation or does not support expected interface.

Can anyone help me please...

Thanks.

 

[Job]

Louie,

Make sure that your not missing any references. VBA window,
tools>references.

hth,

Job

 

[Guest]

Hi Job,

Thanks, I appreciate your reply. I am very new to programming so pls
understand my ignorance..
How can I tell what references is being used by the add-in, is there a way I
can see it on the source code.. Whats a common reference with add-in in Excel.
I have the following check on the reference list.

Visual Basic Application
Microsoft Excel 11.0 Object library
OLE Automation
Microsoft Office 11 Object library
Ms Form 2 Object Library
Ms Scripting Runtime

Am I missing something else.

thank you very much for your help.

Louie

 

[Job]

looks like you have all the basic references. Is it possible that the
add-in your looking to use has an actual form associated with it that is no
longer part of the addin? Perhaps the form was never a part of the addin,
but in the personal.xls and it referenced that form?

 

[Guest]

You are right, I remove the form code associated with this error and its
working fine now.

Now as soon as I click the button on the form say button1.
and has the following codes on it

Private Sub cmdBrowse_Click()
cmdlgFile.fileName = "*.*"
cmdlgFile.Action = 1
If cmdlgFile.fileName <> "" Then
txtFileName.Text = cmdlgFile.fileName
End If
End Sub

I am getting a Run-Time error 424; Object required.

Do you have any idea what object should I cmdlgFile be?

Thanks for working with me on this.. You are really helping me learn more on
Excel programming.

 

[Job]

Look at all the objects on the form. Make sure your properties window is
open(in vba editor) and just click on all the objects on the form and the
form itself to see what the name is referring too...