Error with Set RegExp equal to New RegExp vba

Hi all,

I'm having to try and diagnose a problem with a co-workers PC while running an excel spread sheet with the following vba script placed into an module.

Please Login or Register  to view this content.

The spreadsheet runs fine on my and another co-workers PC. But when trying to run the
same spreadsheet on this other fellows PC it errors.
The error I received is: 430 Class does not support automation or does not support expected interface. I've done some
searching on the subject and found some other similiar issues but no straight forward
resolutions. To start things off, The spreadsheet is located on a network drive. He's
connected through a laptop which we call a toughbook. I'm using a Gateway desktop.
Both are running windows XP and excel 2003. I beleive in order for the RegExp to run,
Microsoft VB Script Regular Expressions 5.5 has to checked in the Reference Library.
This shows to be checked on both our PC's

Does anyone know if there is something else that can effect the spreadsheet from running this specific code?

Any help diagnosing this situation is appreciated.

Thanks,

BDB

Hi Leith,

Here's an excerpt from the WB using the code.
The code can be found in module1, LoadSUBS().


Thanks for your assistance.


BDB

First, I want to re-mention,this code works fine on my PC using Excel2003 but on a
co-workers toughbook(laptop) it's not.

If you toggle between the buttons you should see a new list gets rebuilt in the the first
combobox. You can ignore the 2nd combobox along with the text boxes and command buttons.

If you're referring to the the vbscript.dll in: C:\WINDOWS\system32\
Then, yes it exists.

And

Regular Expressions 5.5 is also checked in the library references when the WB is
loaded.

BDB

Update:

I had one of the IT guys come over and install Excel 2007 on the pc.
This did not fix the problem. I mentioned to him that possibly the problem is not
with the excel program but maybe a corrupt VBScript.dll file. He played around
with this for awhile after finding some informaton about removing the 3 from the file
from within the registry. All this did was remvoe expressions 5.5 from the reference
library. I suggested maybe copying over the VBScript.dll with a copy from another pc.
I copied the one off mine PC drive, since it has shown no issues. This did not
fix the issue. I don't know if a reboot is required after copying over a dll file or not. I had to close the excel program just to copy mine to his.

The only thing left I feel to do is maybe reimage his whole drive
with a new OS copy and go from there.

There's another guy in our dept that uses the same type of toughbook (laptop) as
the one with the problem. I haven't verified yet if his excel will run the macro.
If it does, then maybe reimaging is more a justifiable option.

BDB

Thanks SHG for the input, but replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Only gives me another kind of error: Run-time error '424' Object required.

Again, the code works fine on my PC as is.... but one of the intended users PC is having the issue.

Thanks,

BDB