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

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

Hi Fred

You can use Workbooks.Open

Workbooks.Open ("http://www.microsoft.com")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"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

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

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

Many thanks to all of you who scratched
your heads on my account. A number of
your ideas would indeed have provided a
solution, and I have carefully noted
them. I decided on the Saved Query
approach, in this case. It
automatically does the update each time
the sheet is opened, or more often as
desired.

Again, thanks to you all.

- Fred

"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