Compile Error - Can't find project or libraries

[Mr Nick]

I have recently completed a project and given it out for bug testing. One user has been presented with the compile error when attempting to run any of the macros in the sheet. All machines are running Excel 97-SR2, macros enabled. All users are running the same template file. It onlt affects 1 out of 6 testers - what could be the cause of this problem?

[Tom Schreiner]

Hi
On the machine giving the errors...
Open VBA development environment,
Click on tools, references, and see which reference is missing.
Make sure the workbook in question is up and running.
May be the file was deleted, replaced, or is in the wrong place.

If it is an error on a line with a left, right, mid, or other string function.

Precede the string function with Strings.

For ex.

MyString = Left(MyVar,3)

Change to:

MyString = Strings.Left(MyVar,3)

Have had a lot of problems with this class.

Tom

[Mr Nick]

Hi
On the machine giving the errors...
Open VBA development environment,
Click on tools, references, and see which reference is missing.
Make sure the workbook in question is up and running.
May be the file was deleted, replaced, or is in the wrong place.

The missing reference is:

VideoSoft vsflex2 Controls

winntsystem32vsflexlib.TWD

I cannot uncheck this box as it says it is in use.

Ref Edit Control is checked but is not on any of the other machines.

MS VBA for Extensibility is unchecked on the rogue machine and checked on all others. If you check it, then close the VBA editor and reopen the references, VBA for Ext is again unchecked.

Any ideas on what to do?


[ This Message was edited by: Mr Nick on 2002-04-10 03:20 ]

[ This Message was edited by: Mr Nick on 2002-04-10 03:21 ]

[Tom Schreiner]

Here's an idea. I don't know if it is your only way out of this.

Clear all of the references that you can, some you cannot, delete the sys file temporarily if need be, and then register the libraries via code.

An example for Outlook's Library

ThisWorkbook.VBProject.References.AddFromGuid _
"{00062FFF-0000-0000-C000-000000000046}", 9, 0

You will need to find out where the reference is in the registry.

Regedit, search for the name of the dll,tlb,exe,ocx,twd,ect...

Another thought, an NT machine...
Which service pack?
Permissions?
Who knows...
Out of my ballpark...

Tom

[ This Message was edited by: TsTom on 2002-04-10 03:35 ]

[ This Message was edited by: TsTom on 2002-04-10 03:36 ]

[Mr Nick]

All sorted. Found that the VideoSoft stuff was not on the rogue machine. It's not needed by the sheet so took the references out of the master template via my machine and all is honky dory!

Cheers Tom.

[Tom Schreiner]

We all love a happy ending!
Cheers returned!