Download from the Internet into Excel

[Guest]

When I download data from a particular website it automatically opens in the
internet explorer window as an excel spreadsheet. That’s 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

 

[dominicb]

Good morning Edward

Will a macro suffice?

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

HTH

Dominic

 

[Guest]

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]

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

 

[Guest]

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?