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.
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
When I open the file from VBA script, the dates do NOT display as expected
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.