Hi all,

I have a basic code that I found off the internet that takes a file
from a specifc web page. For a simple example, it is a historical
price file from Yahoo Finance.

1) The way the code currently runs, it opens up an explorer window and
navigates to the page with the file. Is there a way to tweak my code so
that it appears to grab the page behind the scenes?

2) I get the Save As prompt. Can I automatically save it to a
directory of my choice?

Therefore, when I run the module, no additional screens would have been
created, the file would have been saved to my directory automatically
(all behind the scenes).

Assuming these are pretty easy things to get around with VBA, my next
step would be to loop through all files in a directory. Is it possible
to have VBA recognize the number of csv files located at a specific URL
and loop through and do this process for each one? A reference for
what I am talking about would be something similar to this one:

http://www.census.gov/popest/states/...ST2003-02.html

Anyway, I appreciate any feedback you can provide.


--
Btibert
------------------------------------------------------------------------
Btibert's Profile: http://www.excelforum.com/member.php...fo&userid=8559
View this thread: http://www.excelforum.com/showthread...hreadid=537411