dThanks for that - the macro worked but the web address produce by the
datbase company is not an XL file it ends in *.htm - so it does not import.

Why does it read ok on other computers?

"dominicb" wrote:


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