[dsm]

Hi guys,
I need help to resolve a US/AUS date problem.

The following line from a VBA script has worked successfully for a long period of time when used in Excel 97.
Workbooks.Open Filename:="myfile.csv"

I recently upgraded to Office 2003 and the same line now appears to give different results.
-I am located in Australia and the MS Office Language is set to English(Australia)
-The regional and Language settings from control Panel are set to Australia.
-I am running Windows XP

When I open the file directly the dates for a Nov 2005 report appear on screen as expected eg. dd/mm/yyyy
14/11/2005
13/11/2005
12/11/2005
11/11/2005
10/11/2005
9/11/2005

When I open the file from VBA script, the dates do NOT display as expected
14/11/2005
13/11/2005
11/12/2005
11/11/2005
11/10/2005
11/09/2005

I need to open monthly files via a script so I can copy selected components and append them to a master workbook.

Any suggestions greatly appreciated.


Thanks
David

[Advertisements]

Good News,
I kept searching and found a solution at the following URL.

http://support.micro...kb/911750/en-us

[dsm]

Good News,
I kept searching and found a solution at the following URL.

http://support.micro...kb/911750/en-us

[dsenette]

glad you found your sollution...and thanks for posting the link in case someone else has the same problem...sorry we couldn't help