Re: Please help: opening a datastream comma delimited
  Home FAQ Contact Sign in
microsoft.public.excel only
 
Advanced search
POPULAR GROUPS

more...

microsoft.public.excel Profile…
 Up
Re: Please help: opening a datastream comma delimited         


Author: quiettechblue
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
Show full article (0.87Kb)
3 Comments
Re: Please help: opening a datastream comma delimited         


Author: teepee
Date: Mar 16, 2008 08:19

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.
no comments
Re: Please help: opening a datastream comma delimited         


Author: quiettechblue
Date: Mar 18, 2008 19:44

teepee nomail@nomail.com left this in microsoft.public.excel:
>
> 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.
no comments
Re: Please help: opening a datastream comma delimited         


Author: teepee
Date: Mar 19, 2008 04:00

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:
no comments

RELATED THREADS
SubjectArticles qty Group
Re: parsing a tab delimited or CSV, but keep the delimitercomp.lang.perl.misc ·
how so i convert a comma delimited file to an .xls filemicrosoft.public.excel.misc ·