Identifying & Getting Text From IEFrame Class to Clipboard

All,

I am working on automation of obtaining information from a database that is presented to me via an Internet Explorer interface. The database I'm sure is ASP. However, I can not access the ASP for various reasons. Therefore, my attempt in madness is to access the information via a VB type plugin to my Access DB.

I am tired of having to drag/highlight the information. Right Click Copy and then Pasting the data all day long... :mad:

What I do know is that the IE Window over all has the same Name each time, therefore I can get the Hwnd to the overall IE window. However, this window has several frames within it and I need the information from 3 different frames. I used Spy++ to review the information to see if the frames in partiular were different and where they were located in reference to the Parent window.

Appearently these 3 objects are 'Internet Explorer_Server' objects each under their own 'Shell Embedment/Shell DocObject' views. Is there a way to obtain the text/format information from these 3 different frames then relay it to the clipboard, and if so, how do I go about this.

I new to VB programming although I am really pretty good at VBA and standard VBA office automation activities. However, this has me stumped?

I do have snapshots of the Spy++ Property information for the 3 frames along with the properties for the Overall IE Window if this should help...

Any Suggestions?

Mike