I need to do automatic reports, and in order to do that I need my excel file to automatically download some web information. Is there any way to do it with excel Macros? how can I do it?
2007-01-09 01:33:41 · 2 answers · asked by nicobrown84 1 in Computers & Internet ➔ Other - Computers
Better way (I think) than macros:
Go to "Data", then "Import External Data", then "new web query".
Use the link to go to the web page you want to download info from, then checkmark the arrows to select the areas of that web page you want, and finally click "import". Tell Excel where you want the import to go. Then it will import the data directly into Excel. You can then play with the information there. If your website updates, instead of doing it all over again, all you now have to do is have your cursor in that section you just imported, and click on the "!" (or data --> refresh data) button and it will re-import that web page section.
Hope that helps. Took me a try or two to get it how I liked it.
2007-01-09 04:48:44 · answer #1 · answered by Moondog 2 · 0⤊ 0⤋
You can try to use the old fashion style "Copy & paste" or install some web gatter software and it will craw all the website you have keyin the URL, is a nice software.!
Happy Trying...
Regards,
DJ SkyWalker
Professional Computer Engineer @ Cisco
2007-01-09 02:09:25 · answer #2 · answered by DJSkyWalker 2 · 0⤊ 0⤋