PDA

View Full Version : Problems with referencing a .xla file



barasztamas
09-17-2009, 07:00 AM
Dear All,
Please help me with a very mysterious problem:

A .xla file on a shared drive behaves extremely strange on some collagues' machines (Excel2003 on WinXP)
The .xla is referenced from a "normal" .xls file. When they open the .xls the .xla opens with it, you can see it in the VBA window, you can even run programs from it in the VBA window, but the link between the two seems to be broken. When you try to run a .xla program from a .xls program, you recieve a "Can't find project or library" error.
Referencing again doesn't help, opening the .xla before the .xls doesn't help, re-booting the machine doesn't help.
The same files work well on other people's PCs and the same type of referencing with other files (also on shared drives) works well on the same PCs.

:help I'm desperate... :dunno

Thanks in advance
Tamás

I have already posted this on MrExcel, but received no answer. Please post your replies there, if possible (can't post a link, post count too low...)

www[dot]MrExcel[dot]com/forum/showthread.php?t=414501