View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_18_] Ed[_18_] is offline
external usenet poster
 
Posts: 118
Default NEED HELP! Macro didn't survive XP!

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