Macro to get file off the internet

  • Thread starter Thread starter Megadrone
  • Start date Start date
M

Megadrone

Can someone please tell me if it's possible to create an excel macro to go to
the internet and grab a file then save it to my hard drive?
 
The easiest way to do this is to use the macro recorder, and view the results
after you record the process

Turn on the macro recorder:
Tools > Macro > Record New Macro. Then assign your macro to a shortcut key
by clicking in the Ctrl + box (must be a letter, not a number).

Then follow these steps (to import into Excel):
Data > Import External Data > New Web Query.
Then navigate to the site that you want to import from.
Click the yellow arrow next to the data that you want to import, the arrow
will turn into a green check mark, and then click import. Choose the cell
that you want to import to and complete the import.

To run the macro hit Ctrl + the letter key that you assigned the macro to.

Regards,
Ryan---
 
Thanks, but I just want to get the file, i'm not looking to import the data
into a spreadsheet.
 
Back
Top