Hi,

I have an Excel addin (written in VBA) which includes the following line in
a function to open files;

Excel.Application.Dialogs(xlDialogOpen).Show


I am opening a text file which is a list of tab-delimited pairs like;
1 1/3/04
2 2/5/04
3 5/8/04

These dates are ambiguous, in that they are valid dates in either DMY format
or MDY format. My computer's Regional Settings are setup for DMY format, and
in Excel normally, opening this file imports the dates to cells as-is (in DMY
format).

However, with my addin installed, and nothing but the earlier line of code
involved, Excel changes those dates so they are read as MDY formatted. (The
difference can be seen by changing the format of the cells after import to
some non-ambiguous format, e.g; Wednesday, 1st March, 2004)


Any idea why importing this file in an addin context causes the dates to be
formatted unnecessarily?