datesettings cached.. hmm but
excel will react imm. to (applied) changes on the control panel
(which CP also does via a broadcast of setting change msg.)


your solution wont work, or work the same as opening the html.
if xl in "DMY mode" then dates stored in MDY are read
and interpreted.. producing a mixed bag of "swapped" dates or strings
when the day 12.

my solution needs to open a new instance. because the instance running
the proc will "drop" or miss the broadcasted message. all other excel
instances DO respond to the broadcast.

but it DOES work.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


DM Unseen wrote :

KIC,

slept well?<vbg

I see the issue is somewhat trickier that we thought. I suspect the
reason for your problem is that XL stil has its own date settings
internally (like XL 97) and hence actually caches date settings (but
you probably already guessed that)

(PS I think using a querytable and creaing a webquery and setting
WebDisableDateRecognition to true and then do some extra formula/VBA
work would be better, but that's just my 2p.)

aldsv, if tyou find the code is too tricky you could try the
folloiwng:

enable Macro Recorder and start recording
go to Data -Get External Data-new webquery and select/enter your
local HTML file, Also click "advanced"and disable date recognition!
You might need to tweak some other settings as well.
get the data back and close the recorder.
Now use formulas(or VBA) to convert the dates manually, see
http://www.ozgrid.com/Excel/convert-...te-formats.htm for
examples on formulas.

Combine these and put it in your own code.

DM Unseen