View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michelle Hanan Michelle Hanan is offline
external usenet poster
 
Posts: 18
Default Running macro with different references

I looked for that piece of code and it's not in there. My macro merges data
from the worksheet onto word documents, don't know if this changes anything.
By weird I mean it's printing duplicate documents and printing things that
aren't supposed to print, that sort of thing.
"Jim Thomlinson" wrote in message
...
If you recorded a macro in XL 11 and try to run it on 10 there could be
some
issues with backwards compatibility. Most likely (just a guess here but
something to look for) is that you macro performs a sort at some point. In
XL
11 a new parameter was added to the sort functionallity
"DataOption1:=xlSortNormal". Just remove that piece and the code will
probably run OK on the other system.
--
HTH...

Jim Thomlinson


"Michelle Hanan" wrote:

I wrote a macro on my PC about 4 months ago. Now it is being used by
someone
else on a different PC. It still runs just fine for me on my PC, but not
on
her PC. I checked her references and am wondering if it would make a
difference that her office, excel and word are 10.0 object libraries and
mine are 11.0? Could this be what's causing it to run weird on her PC?