 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Please 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 and if i omit Origin and Startrow it gives the same error for ConsecutiveDelimiter > Hello > [quoted text clipped - 13 lines] > Semicolon:=False, Comma:=True, Space:=False, Other:=False, > FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True teepee nomail@nomail.com left this in microsoft.public.excel: > Hello > [quoted text clipped - 8 lines] > > 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? > Does the source filename have a ".csv" extension? No it doesn't. That's the issue. In fact I solved the problem anyway. teepee nomail@nomail.com left this in microsoft.public.excel: >> 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. >> 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:
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.