Hi,

I've currently got an ADODB connection to a CSV file on a fileserver
working over TCP-IP. My VBA looks something like this:

fname = "\\fileserver\directory\file.csv"

With resultLocation.Worksheet.QueryTables.Add(Connection:="TEXT;" &
fname, Destination:=resultLocation)
.attributes = blah
End With

However, the production of our CSV files is now automated as a cron
job on an AIX box and the only feasible way to access them (between
platforms) is accross HTTP. Can I get excel to easily connect over
this protocol, i.e. making my string filename string more like:

fname = "http://internal.server/directory/file.csv"

My first attempts have failed miserably - is this idea going
anywhere?

Thanks,
Louis

What about using a web query ?

NickHK

"LDB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I've currently got an ADODB connection to a CSV file on a fileserver
> working over TCP-IP. My VBA looks something like this:
>
> fname = "\\fileserver\directory\file.csv"
>
> With resultLocation.Worksheet.QueryTables.Add(Connection:="TEXT;" &
> fname, Destination:=resultLocation)
> .attributes = blah
> End With
>
> However, the production of our CSV files is now automated as a cron
> job on an AIX box and the only feasible way to access them (between
> platforms) is accross HTTP. Can I get excel to easily connect over
> this protocol, i.e. making my string filename string more like:
>
> fname = "http://internal.server/directory/file.csv"
>
> My first attempts have failed miserably - is this idea going
> anywhere?
>
> Thanks,
> Louis
>

On 15 Jun, 05:01, "NickHK" <TungChe...@Invalid.com> wrote:
> What about using a web query ?
>
> NickHK
>
> "LDB" <l.br...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > Hi,
>
> > I've currently got an ADODB connection to a CSV file on a fileserver
> > working over TCP-IP. My VBA looks something like this:
>
> > fname = "\\fileserver\directory\file.csv"
>
> > With resultLocation.Worksheet.QueryTables.Add(Connection:="TEXT;" &
> > fname, Destination:=resultLocation)
> > .attributes = blah
> > End With
>
> > However, the production of our CSV files is now automated as a cron
> > job on an AIX box and the only feasible way to access them (between
> > platforms) is accross HTTP. Can I get excel to easily connect over
> > this protocol, i.e. making my string filename string more like:
>
> > fname = "http://internal.server/directory/file.csv"
>
> > My first attempts have failed miserably - is this idea going
> > anywhere?
>
> > Thanks,
> > Louis


Nick,

I've tried using a web query (i.e. connection:="URL;...") but then it
doesn't split the file by the delimitation character specified! It
ends up dumping the whole line (e.g. 234,34545,4444) in one cell...

Any thoughts??

Louis

Apply data>Text To Columns after.

NickHK

"LDB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On 15 Jun, 05:01, "NickHK" <TungChe...@Invalid.com> wrote:
> > What about using a web query ?
> >
> > NickHK
> >
> > "LDB" <l.br...@gmail.com> wrote in message
> >
> > news:(E-Mail Removed)...
> >
> > > Hi,
> >
> > > I've currently got an ADODB connection to a CSV file on a fileserver
> > > working over TCP-IP. My VBA looks something like this:
> >
> > > fname = "\\fileserver\directory\file.csv"
> >
> > > With resultLocation.Worksheet.QueryTables.Add(Connection:="TEXT;" &
> > > fname, Destination:=resultLocation)
> > > .attributes = blah
> > > End With
> >
> > > However, the production of our CSV files is now automated as a cron
> > > job on an AIX box and the only feasible way to access them (between
> > > platforms) is accross HTTP. Can I get excel to easily connect over
> > > this protocol, i.e. making my string filename string more like:
> >
> > > fname = "http://internal.server/directory/file.csv"
> >
> > > My first attempts have failed miserably - is this idea going
> > > anywhere?
> >
> > > Thanks,
> > > Louis
>
>
> Nick,
>
> I've tried using a web query (i.e. connection:="URL;...") but then it
> doesn't split the file by the delimitation character specified! It
> ends up dumping the whole line (e.g. 234,34545,4444) in one cell...
>
> Any thoughts??
>
> Louis
>