Please help: opening a datastream comma delimited

[teepee]

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]

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

 

[quiettechblue]

teepee (e-mail address removed) 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]

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

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

In fact I solved the problem anyway.

 

[quiettechblue]

teepee (e-mail address removed) left this in microsoft.public.excel:

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.