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" wrote:

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?


"Louie" wrote in message
...
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" wrote:

Louie,

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

hth,

Job

"Louie" wrote in message
...
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.

--
Louie