theta
03-06-2012, 07:18 AM
Hey all...coming back for some expert advice as I am a bit stuck. After using the KB and other posts I have constructed a simple macro to start an IE instance and navigate to a page, fire some elements and execute a javascript - all the way through to the production of a crystal report.
I now have a small problem - there is session control in place on the .aspx pages I was using. This is not an issue if doing it manually...log in to the sign in page, open a new IE tab and navigate directly to the Reports.aspx page and the session is valid.
I basically need a VBA macro to scroll through any open instances of InternetExplorer and find which one contains a valid session. This can be detected by seeing if the address is "fcss.xxxxxxx.net" - as this would indicate a valid session is in place.
So if I had 2 instances of IE open, each with 3 tabs - I would need it to scroll through all 3 tabs on instance 1, if no live session is found then move on to instance 2 and scroll through the tabs on there. If found, open a new tab and navigate to reports.aspx. If no live session is found, start a new instance of IE all together and my existing script will run...
Any help appreciated :)
I now have a small problem - there is session control in place on the .aspx pages I was using. This is not an issue if doing it manually...log in to the sign in page, open a new IE tab and navigate directly to the Reports.aspx page and the session is valid.
I basically need a VBA macro to scroll through any open instances of InternetExplorer and find which one contains a valid session. This can be detected by seeing if the address is "fcss.xxxxxxx.net" - as this would indicate a valid session is in place.
So if I had 2 instances of IE open, each with 3 tabs - I would need it to scroll through all 3 tabs on instance 1, if no live session is found then move on to instance 2 and scroll through the tabs on there. If found, open a new tab and navigate to reports.aspx. If no live session is found, start a new instance of IE all together and my existing script will run...
Any help appreciated :)