Please help: opening a datastream comma delimited

  • Thread starter Thread starter teepee
  • Start date Start date
T

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 (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
Click to expand...

Does the source filename have a ".csv" extension?
 
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.
Click to expand...

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