View Single Post
  #6   Report Post  
Posted to microsoft.public.word.tables
Tony Jollans
 
Posts: n/a
Default VBA table sort by date fails intermittently

A couple of things spring to my mind, both of which seem unlikely ...

1. Are you sure the Sort statement in VBA was actually executed?
2. Is there any chance the dates could have been in order according to the
date format on the customer machine?

Only slightly more likely - how have you coded your sort? Might a subset of
cells have been selected at the time and the "Sort Column Only" option be
switched on?

--
Enjoy,
Tony


wrote in message
ups.com...
I have a product whose entire reason for existence is to sort
chronological tables. It was developed and tested using Word 2003, and
also tested on 2000 and 2002. It works fine.
Imagine my dismay when demonstrating it to possible customers yesterday
only to find that the sort feature did nothing!

I saved a copy of the offending file and brought it back to my testbed.
There was no problem sorting it, using both 2003 and 2000. The strange
thing is, the failure at the demo was under 2000 SR3 - the exact same
level of my 2000 testbed. Has anyone any idea what other Word or
Windows modules / release levels could be relevant to any further
investigation?

Looking through this forum, I feel my symptoms are the same as those in
thread

http://groups.google.com/group/micro...owse_thread/th
read/f789b0d65fb5bbb7/0c8c8800648a4e12?q=sort+date&rnum=4#0c8c8800648a4e 12
Sadly this thread was never resolved.

All ideas gratefully appreciated.