Cannot find project or library

V

vbnewbie

I have a VBA project in EXCEL which opens on the machine it was created on ,
is then closed, being saved in a shared documents file on that machine. If it
is opened again on the machine it was created on it is fine, if, however in
the meantime, it is opened on another machine and then closed the next time
it is opened on any other machine I get the above message. My problem is I
need this to work over 6 machines in total.
EXCEL 2002 10 6850 6845 SP3 on one machine
Excel 2002 10.2614 2625 on two of the others
Excel 2003 11.8221.8231 sp3 on the other 3
 
J

Joel

there are tow things you need to check on the machines in Excel.

1) On the worksheet the Tools - Addins.
2) In VBA the Tools - references

Make sure all machines are configured the same in both menus. Once this is
done once it should fix the problem.
 
V

vbnewbie

joel

I will attemot this over the weekend and let you know the result - thanks
very much for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Cannot find project or library 2
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Hyperlink fails to open on the first click 0
Access Runtime 2016 2
Sub projects added as read only in Master file which are saved on sharepoint 1
'Can't find project or library' error 6

Top