Copy Internet pages into excel

Dice · May 8th, 2002, 08:51 AM

Arggghhhh....

This is what i want to happen when i start a macro.

Open Internet explorer
goto http:\www.something.com
copy part of a text
paste it in excel.

I have to do this manually on 15 different pages each day...

Can someone help me plz...plz

"Beginner!"

Mark O'Brien · May 8th, 2002, 09:23 AM

Quote:

Open Internet explorer
goto http:\www.something.com
copy part of a text
paste it in excel.

Questions:

1. Can do
2. Can do
3. How do you determine what text to copy? It's going to be very difficult to do something that doesn't involve selecting the whole page. (read "nigh impossible" for "very difficult")
4. Can do

Dice · May 8th, 2002, 09:35 AM

Thx..

But the problem remains...

i don't know how to do this.

Instead of copying part of the text on WWW, i could copy all, paste it into a different page and then copy the part that i need.

If u could type the whole macro text I would be

Dice · May 8th, 2002, 09:41 AM

There is one more problem...

On the page where I copy from the files are not always updated.. have u got an idea on how to give the user a message when there is no file to recive..

Mark O'Brien · May 8th, 2002, 09:41 AM

Have a look at this thread:

http://www.mrexcel.com/board/viewtop...c=3100&forum=2

HTH

Dice · May 8th, 2002, 09:52 AM

Thanks

Trying to figure out that code...hmmm...

I think i gonna use a couple of days on this one.....

See ya...

Mark O'Brien · May 8th, 2002, 10:03 AM

Remember to post here if anything is really stumping you.

Have a nice day. Yawl.

Thomas · May 8th, 2002, 10:44 AM

Dice -

I'm not sure if this is what you need, in that you didn't give specifics in your original post, but Microsoft offers a Web connectivity kit that 'extensively details how to use Excel with the Web and vice versa and includes sample Excel and HTML files to also achieve this goal'.

It can be downloaded free at http://office.microsoft.com/download.../webcnkit.aspx

Hope that helps

~Thomas

Dice · May 8th, 2002, 11:57 AM

Perfect........

This is what I was looking for...... Lovely......

Thank you....

Dice · May 9th, 2002, 09:15 AM

Here is another problem...
(they never seem to end)

The files I download from the internet is not always there.

When I run a macro that updates all the files, the macro stops if one of the files are missing.

I would rather have it to give me a message saying "The file something.txt is not updated yet".

I would also like to make a choice when this message appear.

Something like "Continue" and "Stop"

Can you help me whith this one??

May 8th, 2002, 09:41 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have a look at this thread: http://www.mrexcel.com/board/viewtop...c=3100&forum=2 HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 8th, 2002, 10:03 AM	#7
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Remember to post here if anything is really stumping you. Have a nice day. Yawl. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 08:51 AM	#1
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Arggghhhh.... This is what i want to happen when i start a macro. Open Internet explorer goto http:\www.something.com copy part of a text paste it in excel. I have to do this manually on 15 different pages each day... Can someone help me plz...plz "Beginner!"

May 8th, 2002, 09:35 AM	#3
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Thx.. But the problem remains... i don't know how to do this. Instead of copying part of the text on WWW, i could copy all, paste it into a different page and then copy the part that i need. If u could type the whole macro text I would be

May 8th, 2002, 09:52 AM	#6
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Thanks Trying to figure out that code...hmmm... I think i gonna use a couple of days on this one..... See ya...

May 8th, 2002, 10:44 AM	#8
Thomas Board Regular Join Date: May 2002 Location: Dallas Posts: 365	Dice - I'm not sure if this is what you need, in that you didn't give specifics in your original post, but Microsoft offers a Web connectivity kit that 'extensively details how to use Excel with the Web and vice versa and includes sample Excel and HTML files to also achieve this goal'. It can be downloaded free at http://office.microsoft.com/download.../webcnkit.aspx Hope that helps ~Thomas

May 8th, 2002, 11:57 AM	#9
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Perfect........ This is what I was looking for...... Lovely...... Thank you....

May 9th, 2002, 09:15 AM	#10
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Here is another problem... (they never seem to end) The files I download from the internet is not always there. When I run a macro that updates all the files, the macro stops if one of the files are missing. I would rather have it to give me a message saying "The file something.txt is not updated yet". I would also like to make a choice when this message appear. Something like "Continue" and "Stop" Can you help me whith this one??