Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 8th, 2004, 09:57 AM
Registered User
 
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel text Import and VB

hi guys,

I've read the International Issues Part II document about that subject (and that's how i discovered the forum), but the advices provided are still not working for my case.
I'm trying to import a csv file using a VB macro. The code i use is very basic. My date are in european format (dd/mm/yy).
But even if my regional settings are setup like this, and my code says:
Workbooks.OpenText toto, xlWindows, , xlDelimited, , , False, True , , , , , _
Array(Array(1, 4), Array(14, 4), Array(17, 4), _
    Array(19, 4), Array(21, 4), Array(23, 4), _
    Array(25, 4), Array(27, 4), Array(29, 4), _
    Array(31, 4))
I still have some dates that are imported the wrong way (for example, a 1st september 2003 (01/09/2003) is considered as a 9th Jan 2003)...
Does any of you have an idea on how i could manage that?

Thank you very much for your help.

Franck






Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from Excel sheet to a text file zone Excel VBA 1 July 26th, 2007 10:34 AM
Import Excel to VB.Net stealthdevil Visual Basic 2005 Basics 4 June 6th, 2007 01:10 PM
import data from text file to excel(VBA) topr Excel VBA 2 August 26th, 2004 11:36 PM
Excel IMport Text Help!! money Excel VBA 2 April 30th, 2004 12:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.