Macro to get file off the internet
 

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?

Macro to get file off the internet
 

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---


--
RyGuy


"Megadrone" wrote:

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?

Macro to get file off the internet
 

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

"ryguy7272" wrote:

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---


--
RyGuy


"Megadrone" wrote:

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?