Hello:

I am trying to import a comma delimited file into Excel (it can be int
a new workbook). I have tried to create a Macro to automate the process
When I run my macro excel dumps it all into the A column. It also adds
box type symbole between the columns. Any ideas of what I am doin
wrong, or can this not be done by using macros. The code for the macr
is as follows:

Sub Web_Upload()
'
' Web_Upload Macro
' Macro recorded 10/7/2004 by
'

'
Workbooks.OpenText Filename:="\\Hd1\exceldir\webupload", Origin:=437,

StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=Tru
_
, Space:=False, Other:=False, TrailingMinusNumbers:=True
End Sub



Thanks for your help in advance

--
Te_Didd
-----------------------------------------------------------------------
Te_Diddy's Profile: http://www.excelforum.com/member.php...fo&userid=1113
View this thread: http://www.excelforum.com/showthread.php?threadid=26775