mschoenrock
May 30th, 2001, 02:58 PM
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
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