VBA to Access External Web Page?

[Brian Michalk]

I am trying to download a CSV file from a remote web server (Linux) and parse
the file to update work completed in my project.

I can't figure out how to even instantiate a simple socket to connect to the
server. What's the best way to do this? I don't think SOAP is the answer,
but perhaps I'm wrong.

 

[Rod Gill]

I suspect you will need to create a separate program to regularly download
that file to a known folder, then read the file from that folder with VBA.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Brian Michalk]

Does this apply to all VBA scripts, or is this peculiar only to MS Project?

 

[Rod Gill]

VBA doesn't easily interface to SOAP etc (at least I don't know how to do
it!) So you are probably better off creating a tool in your favourite
programming language to download the file each night, then read the file
directly from VBA. VBA is brilliant for working with Office applications,
text files and using OLEDB to talk to databases etc but not much else.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx