I am going out to the web to retrieve them, which is the key to the problem. I got something kind of working last night - I have pasted it below...
I won't have access to the database till tonight, so I can't test it till then. This appears to get at least part of the page. A few test have just brought in a portions, but I am wondering if it is pulling the source before it is finished downloading, so perhaps a button which I could click once it is fully loaded may be a better idea - Let me know what you think, or if you have any better ideas. I did just notice a download complete event - I think I will try that. Also, do you by chance know where I could get some documentation on this control - I tried on msdn last night, but gave up after 30 minutes or so.
Private Sub ocxBrowser_Updated(Code As Integer)
On Error Resume Next
strFile = "F:\DeleteMe.txt"
Set objIE = Me.ocxBrowser.Object
Open strFile For Output As #1
Print #1, objIE.Document.body.innerHTML
strURL = objIE.Name