Source Code of webpage

[Sanka]

I would just like to know if it is possible to get the source code of a webpage through VB in Access. I need to copy the code to another webpage after that.

If anyone knows how to do that please let me know

Thanks

[nico5038]

It is, just create a form with the Webbrowser control.
Now you can point to an URL with:

Me.webbrowser1.Navigate URL:="<the needed URL e.g. from your form>"

When the page is visible you need to use:

Dim doc As MSHTML.HTMLDocument
Set doc = Me.webbrowser1.Document

To get the browser data available and personally I use only selected text on such a page like:

strSelectedText = doc.selection.createRange().Text

There's more to this, but you'll have to check the HTMLDocument options to get it all.

Nic;o)