I distribute excel based solutions from an XP machine to other machines on
our network also. What I have found is that the other machines need to have
current patches and updates for their particular OS version and then they
work fine. Also some references in the VBA code has to be done at run time
rather than at development time, so you have to change a little bit of
coding to do run time references. So 1) get patches and updates, especial
for Office from Windows update site for all the machines you will distribute
to. 2). Change your code to do run time references instead of development
time references.


You should then be ok.
Dennis

"Ed" wrote in message
...
My workbook, which is published on the network, worked fine when saved
from
Win/XL2000. I've been "improved" to XP. Yesterday was my first
distribution since the change. I did not change *any* code in the
workbook.
I got bit by the first "It won't work" today - of course, it's saved as an
XP version and won't open on 2000 machines. So I did a SaveAs Microsoft
Excel 97-2002 & 5.0/95 Workbook, and it opened okay on a 2000 machine.

NOW, though, a code in the workbook won't work. It has always worked fine
(for about a year now). And the XP version works fine on my machine. The
code (copied below) threw up a "Can't find project or library" error,
highlighted at Cell in For Each Cell in rng..... A check of the
references
showed MISSING: Word 10.0 Object Library!! Errors on Cell, and missing a
WORD library?!?

Can anyone help me?

Ed