When I download data from a particular website it automatically opens in the
internet explorer window as an excel spreadsheet. Thats fine. However the
icons at the top of the spread sheet which allow copy, paste, save etc. are
all greyed out which means the spreadsheet information cannot be used. I have
tried this on another computer and it works fine so I assume it must be
something to do with the settings on my computer any help? I have excel2002
and ie6 with windos xp professional

Good morning Edward

Will a macro suffice?

Sub Test()
Workbooks.Open Filename:="http://www.myweb/xlfiles\myfile.xls"
End Sub

HTH

DominicB


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

thanks dominicb - not sure how I can use this. The problems lies in internet
explorer in that I cannot copy the spread sheet in view.

"dominicb" wrote:


Good morning Edward

Will a macro suffice?

Sub Test()
Workbooks.Open Filename:="http://www.myweb/xlfiles\myfile.xls"
End Sub

HTH

DominicB


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

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

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