How do I select already open IE win and save its web page source code to local *.txt file?

[RX180]

I need to grab some public data from a website, but the data in question is only accessible if the user clicks in an link that opens a new IE window with the desired data. Despite being newbie to Excel / VBA I managed to do a rudimentary code able to click on the link that opens the window with the desired data. Here is my code:

Please Login or Register  to view this content.

So far everything is working fine.

Now I need a code to select the new opened window and save the source code of it's webpage to a local *.txt file. I have tried some examples, including queries to the first page that shows the desired data too, but none worked. The only way I found to grab the data was saving the source code of the second web page to disk and parsing it.

Can someone help me?

[nathansav]

There is a piece of code for this on here, a week or so ago, try searching the forum.

[RX180]

There is a piece of code for this on here, a week or so ago, try searching the forum.

I tried it two times, but advanced search appears not working: header('HTTP/1.1 503 Service Temporarily Unavailable'); header('Status: 503 Service Temporarily Unavailable'); header('Retry-After: 17200'); // in seconds print "TEST123";

[Sean Thomas]

This should do it

Please Login or Register  to view this content.

[Sean Thomas]

This one will run through all ie.applications open

Please Login or Register  to view this content.

[Marc L]

Please Login or Register  to view this content.

[RX180]

This should do it

Please Login or Register  to view this content.

This code worked with (.Count - 1)! But, instead navigate to "http://support.microsoft.com/kb/q176792/" I need to save the webpage source code to a *.txt file. Can You give me a bit more help with this? (I'm suffering of hepatic encephalopathy.) Thank You, Sean!

[Marc L]

To grab data is not necessary to save source codepage to a file …

[RX180]

To grab data is not necessary to save source codepage to a file …

I suppose You are right, Marc. Can You give me a simple example inserted in the code below? I asked about save web page code to file cause I feel more confortably parsing *.txt files saved to disk... (I am old and sick. Then, if possible, I want to do an task without spend much time learning new things...)

This is our code until now:

Please Login or Register  to view this content.

[Sean Thomas]

can you give out the url? there might be an easier way to get the data without saving it as txt. As Marc indicated, if we know what you want to get from the site I have some code that will open a url, make any changes, press buttons and then get the data from the updated site. This might be easier if you give some more info as to what you are doing. PM me if it is confidential.

[Marc L]

Agree with Sean.

'Cause structure is different from a webpage to another one, there are different ways to grab data.

Exemple in this thread to grab a table by using the clipboard …

[RX180]

can you give out the url? there might be an easier way to get the data without saving it as txt. As Marc indicated, if we know what you want to get from the site I have some code that will open a url, make any changes, press buttons and then get the data from the updated site. This might be easier if you give some more info as to what you are doing. PM me if it is confidential.

This is no longer necessary. I managed to save the web page code to disk with this code:

Please Login or Register  to view this content.

Thank you very much, Sean.

[RX180]

Agree with Sean.

'Cause structure is different from a webpage to another one, there are different ways to grab data.

Exemple in this thread to grab a table by using the clipboard …

Read my response to Sean, Marc. Thank you very much!