Speaking of Office automation, try this:

Make sure your regional settings are non-US (British or whatever).
Create an Excel sheet with some dates in it.
Create a mailmerge document in Word linked to the Excel sheet.
(this is what we automate in our app BTW, works well for mailshots etc)

Look at the resulting word document.
ALL THE FRIGGING DATES ARE IN AMERICAN FORMAT!!!
Arrrghhh!

The solution is to update the merge format to force the date to
dd/mm/yyyy (i.e. the same as I specified in regional settings).

-- 
Paul


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to