Compile Error - Can't find project or libraries

Mr Nick

Board Regular
Joined
Mar 11, 2002
Messages
95
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?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top