Mid statement object reference error.

[mmf]

I have an application that is working in my machine, but when I bring it to another user machine didn;t work.

I use some of the VBA string manipulation functions such as Mid, Instr etc.
Everyone is using Excel 2003 SP-3, and in the other machine is 2002 SP-3
all security level are setted low.

However one the other user gets an error on the Mid statement "Cannot find Project or Library".

However i do not have this problem in other computers.

I checked that the references in VBA are identical, so I am a bit in the dark here.
Any comments or suggestions to what is going on?

Can i make an executable file that bring me everything that I need, so I can transport the file every were in any machnie and make it work?
thanks very much

[Leith Ross]

Hello mmf,

I have had this problem in the past. I have found that the VBA portion of Excel becomes corrupted. The rest runs fine. This method has worked for me...

Rebuild Excel from the Command Line
1. Click Start, and then click Run...
2. In the Open box type this Excel.exe /unregserver
3. Excel will run then close.
4. Click Start, snd then click Run...
5. In the Open box, type Excel.exe /regserver
6. Excel will run then close.

This will rewrite all of Excel's registry keys and reassociate itself with Excel files, such as workbooks, charts, and others.

Sincerely,
Leith Ross

[mmf]

Leith
thanks very much for the suggestion, I tried that one but unfortunatly didn't work. Any other idea what could be the problem?
thanks very much
Marcos

[Leith Ross]

Hello Marcos,

The only other option would be to have the user re-install Excel on their machine, and make sure all the VBA components are installed this time.

Sincerely,
Leith Ross