Importing from Web

[hockeyman99j]

I am looking to automatically import a file into excel from the web with the click of a button. I know how to do this with .txt files, etc. but I am wondering if I can do the same with a .xls file?? Here is an exact table that I am looking to import. http://www.census.gov/const/www/c30index.html

Thanks

 

[hockeyman99j]

There is also a PDF version if this makes it any easier to automatically import it to excel using a macro?

 

[John_w]

File - Open and specify the XLS URL as the file name, e.g. http://www.census.gov/const/C30/totsa.xls. Do this with the Macro Recorder running to determine the VBA code required to open the file automatically.

If you want to import all the XLS files without knowing their URLs you could use InternetExplorer automation on your web page and loop through the Document.links collection looking for links containing ".xls".

 

[hockeyman99j]

Thanks John!