jpiller
Apr 7th, 2004, 10:00 AM
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!
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!