ADODB over HTTP?
Apply dataText To Columns after.
NickHK
"LDB" wrote in message
oups.com...
On 15 Jun, 05:01, "NickHK" wrote:
What about using a web query ?
NickHK
"LDB" wrote in message
oups.com...
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(Connectio n:="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
|