I did file=Open and pasted in the URL
http://ep.kicks-ass.org/phpBB2/Minerals/

worked fine for me.

in code

workbooks.Open Filename:=http://ep.kicks-ass.org/phpBB2/Minerals/"

--
Regards,
Tom Ogilvy


"FredC" wrote in message
.. .
Excel 2000
http://tinyurl.com/6ue3f


"Don Guillett" wrote
in message
...
Your excel version?
the url___________?

--
Don Guillett
SalesAid Software

"FredC" wrote in
message
.. .
I want to copy all of the data on a
webpage and paste it to an Excel
spreadsheet
cell/range.

I have the hyperlink on the
spreadsheet
and can click it with a macro, but I
can't copy the page in the macro. It
just stops when IE opens.

Would someone please offer a code
snippet to put me on the track?

- Fred