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

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.

"vbnewbie" wrote:

> 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

joel

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

"Joel" wrote:

> 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.
>
> "vbnewbie" wrote:
>
> > 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