Re: How do I import several csv files into one excel worksheet?

From: marksince1984 <marksince1984.28uvay_1149387301.3514@xxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 3 Jun 2006 21:11:02 -0500

There is a check in there that the folder contains csv files, it is this
i need to get around. Any ideas?

Dave Peterson Wrote:

Without any testing...

'Open the TXT file in Excel
Application.ScreenUpdating = False
Workbooks.OpenText Filename:=TXTFileName, Origin:=xlWindows, StartRow
_
:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True,
_
Space:=False, Other:=False

becomes:

'Open the TXT file in Excel
Application.ScreenUpdating = False
Workbooks.OpenText Filename:=TXTFileName, Origin:=xlWindows, StartRow
_
:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=TRUE, Semicolon:=False, Comma:=FALSE,
_
Space:=False, Other:=False

--
marksince1984
------------------------------------------------------------------------
marksince1984's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33484
View this thread: http://www.excelforum.com/showthread.php?threadid=546042

.

Follow-Ups:
- Re: How do I import several csv files into one excel worksheet?
  - From: Dave Peterson

References:
- Re: How do I import several csv files into one excel worksheet?
  - From: marksince1984
- Re: How do I import several csv files into one excel worksheet?
  - From: Dave Peterson

Prev by Date: Re: Subtracting 2 hours from time
Next by Date: Re: format painter wont copy mixed font colors from one cell to next
Previous by thread: Re: How do I import several csv files into one excel worksheet?
Next by thread: Re: How do I import several csv files into one excel worksheet?
Index(es):
- Date
- Thread

Relevant Pages

Re: excel.exe - Corrupt File
... I have a difficult time finding that folder, ... "Dave Peterson" wrote: ... You can close excel and delete that file. ... "Shane Devenshire" wrote: ...
(microsoft.public.excel)
Re: REPOST: Excel 2003 - open a fle and get 2?
... from excel to visio. ... MCHSI wrote: ... Click the OK button and see what's in that folder. ... Dave Peterson ...
(microsoft.public.excel)
Re: REPOST: Excel 2003 - open a fle and get 2?
... from excel to visio. ... MCHSI wrote: ... Click the OK button and see what's in that folder. ... Dave Peterson ...
(microsoft.public.excel)
Re: Specifying working folder
... I changed it to an existing folder, ... "Dave Peterson" wrote in message ... You could start excel in safe mode: ... > Hit alt-f11 to get to the VBE (where macros live) ...
(microsoft.public.excel.misc)
Re: New worksheet is in compatibility mode
... I tried again to save a blank workbook that I converted ... came up with an error message that the folder is Read Only. ... Workbooks\Save files in this format--and I select Excel Workbook, ... "Dave Peterson" wrote: ...
(microsoft.public.excel.misc)