Macro to Open webpage, then save webpage as txt file.

**jasocke2** · 10-09-2009, 06:58 AM

Hi,

I have the following code which opens a webpage from Excel and then waits until it finishes loading and that is how far I have got...

Please Login or Register  to view this content.

The next stage is that I am wanting it to save the webpage as a text file:
(From IE window (File->Save As->......Save As Type-> Text File *.txt) with a file name which is located in say cell A1 in the workbook.

I would just import it into Excel and do it that way however there is quite a lot of data.

Is this possible?

I have attached an example txt file of what I am looking for if it was done for google.com.

**Chippy** · 10-09-2009, 12:25 PM

See if http://www.excelforum.com/excel-prog...and-paste.html helps. It's similar to your requirement, but copies the web page to the clipboard and then pastes it to the Excel sheet. There is probably a way to write the clipboard contents to a text file instead in VBA, alternatively loop through the cells and write them to a file.

**Leith Ross** · 10-09-2009, 02:52 PM

Hello jasocke2,

Here is macro that will save the web page text into a text file. Change the URL and file (both in red) to what you will be using.

Please Login or Register  to view this content.

**Scafloc** · 04-12-2012, 05:31 AM

I have tried this and the weird thing is that it works depending on the website that you go to.

For instance it works for google and also to get info from the api of a russian wiki:

http://7kingdoms.ru/w/api.php?action...=500&gapfrom=0

However it does not work for the api of a french wiki:

http://www.lagardedenuit.com/wiki/ap...=500&gapfrom=0

You get the runtime error "Object required"

Also I tested it yesterday for booth wikis and I think it worked then (not complete sure if I tested it on the French one). Since yesterday I downloaded a new version of the IE. Anybody an idea what the problem is?

**Scafloc** · 04-12-2012, 03:31 PM

The problem was IE; I downgraded IE back to 8.0 and now it works again.

**MaczaQ** · 04-12-2012, 04:01 PM

other way for get source web-page with GET method

Please Login or Register  to view this content.

Some day I've used IE object for get web page source but it was a bit slow - using above code I speed up getting result about x 10. If you need to get result many times in loop etc. then this should be faster way.

**TonyExl** · 06-07-2012, 03:54 AM

dear maczaq,

i've tried yours & it works.
however, how to deal with "characters in other languages" (say coding in "Big5" chinese) for objHTTP.responseText ?
these characters are just incorrectly displayed as "????" in the txt file.
do u have any idea ?

thx,
tony

Originally Posted by maczaq

other way for get source web-page with GET method

Please Login or Register  to view this content.

Some day I've used IE object for get web page source but it was a bit slow - using above code I speed up getting result about x 10. If you need to get result many times in loop etc. then this should be faster way.

**arlu1201** · 06-07-2012, 04:25 AM

TonyEXL,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.