PullingHairOut
New Member
- Joined
- Apr 12, 2011
- Messages
- 1
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
First time poster so please let me know if I’ve done anything i shouldn't. <o></o>
<o> </o>
I’ve been thru the forums and can’t find a solution to this specific problem.<o></o>
<o></o>
I've been trying on and off for over a year to do as described below and never find a working solution... anywhere! Forums, MSDN, etc... All have close to what i need but never end up being able to do what I need.<o></o>
<o></o>
Summary:<o></o>
- Launch IE window and login to a secure site (using createobject) - no issues at this step<o></o>
- Launch a web based application (Citrix) - no issues at this step<o></o>
- While the app launches an "app is loading" box comes up, followed by cmd window, then lastly an IE window (this is the window I want to have as an object so I can automate it). - No issues at this step<o></o>
<o></o>
<o></o>
At this point currently i have to go to a reporting site and open an excel file report, then Alt+F11 to open VBA (Citrix Side), and i paste the code into the VBA window and run it. - No issues at this step<o></o>
<o></o>
What I want to accomplish is to be able to make the newly opened IE window (the web based app) an object like any other IE window so i can run my code without needing to paste my code into a new VBA window on the Citrix side. This is preventing me from fully automating my data extraction from the reporting sites.<o></o>
<o> </o>
NOTE: I cannot save any type of file in the Citrix environment, which is the reason for automating in the first place.<o></o>
<o> </o>
<o> </o>
What I have currently coded to give info about the new window:<o></o>
<o> </o>
- I find the hWnd for the window and bring it to the top which I can then do things to the window itself, just not within the window (i.e.; enter a URL)<o></o>
- Played with sendkeys but doesn’t give enough functionality to be able to do what I need (i.e.; enter a URL)<o></o>
- Tried creating an object that launches the app but I imagine because of the loading window, and cmd window, it can’t have the app window (3<SUP>rd</SUP> window in the launch sequence) as the IE object.<o></o>
- And a few other futile attempts all were stabs in the dark, which I knew wouldn’t work but had to try, just in case.<o></o>
<o> </o>
Hope I’ve given enough info to be able to get help from someone, if I haven’t just let me know and I’ll gladly go into more details. Except for details of the citrix environment – server address and names, details about the applications, etc… these are confidential and I can’t give out that information, but since what I need to do is control an IE window they shouldn’t be needed anyway.<o></o>
<o> </o>
<o> </o>
Thanks in advance for any help you can provide… even if the help is to say this can’t be done (with an explanation as to why it can’t be done – if possible).<o></o>
Sincerely,<o></o>
PullingHairOut
fficeffice" /><o></o><o
></o>First time poster so please let me know if I’ve done anything i shouldn't. <o
></o><o
> </o>I’ve been thru the forums and can’t find a solution to this specific problem.<o
></o><o
></o>I've been trying on and off for over a year to do as described below and never find a working solution... anywhere! Forums, MSDN, etc... All have close to what i need but never end up being able to do what I need.<o
></o><o
></o>Summary:<o
></o>- Launch IE window and login to a secure site (using createobject) - no issues at this step<o
></o>- Launch a web based application (Citrix) - no issues at this step<o
></o>- While the app launches an "app is loading" box comes up, followed by cmd window, then lastly an IE window (this is the window I want to have as an object so I can automate it). - No issues at this step<o
></o><o
></o><o
></o>At this point currently i have to go to a reporting site and open an excel file report, then Alt+F11 to open VBA (Citrix Side), and i paste the code into the VBA window and run it. - No issues at this step<o
></o><o
></o>What I want to accomplish is to be able to make the newly opened IE window (the web based app) an object like any other IE window so i can run my code without needing to paste my code into a new VBA window on the Citrix side. This is preventing me from fully automating my data extraction from the reporting sites.<o
></o><o
> </o>NOTE: I cannot save any type of file in the Citrix environment, which is the reason for automating in the first place.<o
></o><o
> </o><o
> </o>What I have currently coded to give info about the new window:<o
></o><o
> </o>- I find the hWnd for the window and bring it to the top which I can then do things to the window itself, just not within the window (i.e.; enter a URL)<o
></o>- Played with sendkeys but doesn’t give enough functionality to be able to do what I need (i.e.; enter a URL)<o
></o>- Tried creating an object that launches the app but I imagine because of the loading window, and cmd window, it can’t have the app window (3<SUP>rd</SUP> window in the launch sequence) as the IE object.<o
></o>- And a few other futile attempts all were stabs in the dark, which I knew wouldn’t work but had to try, just in case.<o
></o><o
> </o>Hope I’ve given enough info to be able to get help from someone, if I haven’t just let me know and I’ll gladly go into more details. Except for details of the citrix environment – server address and names, details about the applications, etc… these are confidential and I can’t give out that information, but since what I need to do is control an IE window they shouldn’t be needed anyway.<o
></o><o
> </o><o
> </o>Thanks in advance for any help you can provide… even if the help is to say this can’t be done (with an explanation as to why it can’t be done – if possible).<o
></o>Sincerely,<o
></o>PullingHairOut
