LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Opening CSV files with VBA/macro

XL2000:
When a open this CSV file through EXCEL normal interface,
the files gets correctly formatted when it opens without
asking any questions. A date field present is interpreted
and formatted as dd-mm-yy.
If I record these actions and run then run the macro, the
file gets the wrong format in this "date field". It treats
the dates as mm-dd-yy! So half of the dates in the file do
not get recognized as dates (dates where day 12)
Again, this last behaviour only happens if you use the
macro to open it.

Glad to hear any help!

Vasco
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Files - Macro Max2073 Excel Worksheet Functions 1 December 10th 09 06:06 AM
Opening Files Using a Macro Mark Costello[_2_] Excel Discussion (Misc queries) 0 January 29th 08 03:48 PM
show most recent files first when opening excel files Anne` Excel Discussion (Misc queries) 5 January 23rd 08 01:54 AM
Macro for opening files that changes names [email protected] Excel Discussion (Misc queries) 1 May 12th 07 06:15 PM
Opening text files using macro Ron de Bruin Excel Programming 0 July 9th 03 02:49 PM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"