Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL data transposition when saving in VB

Status
Not open for further replies.
BobChesh

BobChesh

Technical User
Dec 13, 2001
39
GB
I have a CSV file which contains data in the dd/mm/yy hh:mm format (01/06/03 11:35)

When I save this using VB, either using Filename.SaveAs:=myfile

or

Filename.Save

then when re-opened, the format of tha data is in mm/dd/yy hh:mm, (06/01/03 11:35). Yet when I save it manually then it saves in the orginal format.

Any ideas why, or a fix that I can impliment to overcome this problem

Cheers
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
1K
dhookom
dhookom
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
648
combo
combo
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo
kwbMitel
  • Locked
  • Question
Lost edited data in Excel File
Replies
3
Views
356
Scott24x7
Scott24x7
Scott24x7
  • Locked
  • Question
Help when printing rows and objects in Excel
Replies
4
Views
381
combo
combo

Part and Inventory Search

Sponsor

Back
Top