Wierd Excel 2000 Add-in Problem...[RESOLVED]

[jpiller]

Hello All!

I am at the end of my rope and have done all I can to try and fix this little issue of mine...

Here's the situation...I have created an Excel Add-in that manipulates a text file, does a VLOOKUP on another Excel file and all that works great, but the problem is this: On the one computer that I need this to work on, I keep getting an automation error...when I go into the VBE to try and figure out the problem and make a change, it does not allow me to save the project at all....here's the real twist...on every other machine that I have installed this thing on, it works with no problems at all! The add-in works perfectly with no automation errors or anything.

I have been looking around the forums, but I think I have narrowed the problem down to the form that I am using...the first call to the add-in is this:

Sub OpenBrowse()
frmBrowse.Show
end sub

I don't know how this is wrong, but it's like when we load the add-in and we load a new blank worksheet and click the button, Excel can't find the form? We are using Excel 2000, FM20.DLL is the form controls that are being used....

Additionally, when I click on the form and try and do anything there, I get an error that the form cannot be modified????

in short, HELP!!!

Any help is appreciated greatly!

Thanks,

Jim P.

--- RESOLUTION ---

The resolution to this issue was with the Comdlg32.ocx file. For some reason the file had either gone bad or was unregistered. I logged in as Administrator on the PC that was having the problem and then re-registered the OCX file and that worked like a charm!