Author: quiettechbluequiettechblue Date: Mar 15, 2008 11:39
teepee nomail@ nomail.com left this in microsoft.public.excel:
> Hello
>
> Anyone help? I'm trying to open a data stream in excel from my own
> remote server which uses comma delimitation and I'm trying to get
> Excel to open as such, instead of sticking all the data in one column.
>
> Someone suggested the code below might work from but on 'startrow' it
> throws up a 'compile error' that 'named argument is not found'.
>
> Anyone have an idea how to do it? I'm no expert.
>
> Workbooks.Open
>
> Origin:=437, Startrow:=1, DataType:=xlDelimited,
> TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False,
> Semicolon:=False, Comma:=True, Space:=False, Other:=False,
> FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True
|