View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dominicb
 
Posts: n/a
Default Download from the Internet into Excel


Hi Edward

The code I've given you will open the workbook in XL, not IE, so you
can edit it, save it etc.

Open XL and in a blank workbook press alt + F11

Go to Insert Module

Paste my code into the pane that appears (obviously replace my made up
address and file name with the real one)

File Close & Return to Excel

Tool Macro Macros, Run

should open the file.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=485798