Please help: opening a datastream comma delimited

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
Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806",
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

teepee
Tue Mar 11 10:23:18 CDT 2008

and if i omit Origin and Startrow it gives the same error for
ConsecutiveDelimiter

"teepee" <nomail@nomail.com> wrote in message
news:47d6a080@newsgate.x-privat.org...
> 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
> Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806",
> 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
>

quiettechblue
Sat Mar 15 13:39:55 CDT 2008

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
>
Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806",
> 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

Does the source filename have a ".csv" extension?

teepee
Sun Mar 16 10:19:58 CDT 2008


<quiettechblue@yahoo.com> wrote
>
> Does the source filename have a ".csv" extension?

No it doesn't. That's the issue.

In fact I solved the problem anyway.

quiettechblue
Tue Mar 18 21:44:56 CDT 2008

teepee nomail@nomail.com left this in microsoft.public.excel:

>
> <quiettechblue@yahoo.com> wrote
>>
>> Does the source filename have a ".csv" extension?
>
> No it doesn't. That's the issue.
>
> In fact I solved the problem anyway.

Thank you for the feedback. It makes the thread far more valuable.

teepee
Wed Mar 19 06:00:33 CDT 2008


<quiettechblue@yahoo.com> wrote

>> In fact I solved the problem anyway.
>
> Thank you for the feedback. It makes the thread far more valuable.

Good point. I forgot to say what worked.

The trick was to say

Workbooks.OpenText Filename:

instead of

Workbooks.Open Filename: