Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

US vs AUS date problem with Excel 2003 VBA


  • Please log in to reply

#1
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
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
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Topic Starter
  • Member
  • PipPip
  • 98 posts
Good News,
I kept searching and found a solution at the following URL.

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

#3
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
glad you found your sollution...and thanks for posting the link in case someone else has the same problem...sorry we couldn't help
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP