Is the CSV file linked from a URL on a page, or the result of a form
submission ?

If a link (or form submission using GET) then you could probably download it
directly using xmlHttp.

Tim


"Dave N" wrote in message
...
Thanks for your help with this Tom,
My application runs in Excel and I am using the Internet Explorer object
model (references the WebBroser Control - ShDocVw.dll). What I really need
to
know is is there a way of changing the default Save As directory through
this
or any other way while using VBA? You mentioned changing the registry
using
WScript.Shell object - can this be done in VBA?
Regrards
Dave

"T Lavedas" wrote:

On May 7, 12:22 pm, Dave N wrote:
Hi,
I need some help with automating Internet Explorer using VBA. I have an
application to runs a report on our Internet based system and which can
be
downloaded as a csv file. In order to save this file into the correct
location I need to change the directory that intintially pops up in the
'Save
As' dialog box. This defaults to the last location used. Can anyone
please
suggest a way of doing this? For example, in Excel I would use the
ChDir
statement, is there a similare statement for IE?
Any help would be much appreciated!
Dave