Help to enhance/improve this vb script

[Jovillanueva]

Hi Expert,

I have a vb script that call/open an SSRS link from IE9. Right now my script displayed/open only 1 page.
May I ask your help to enhance this script.

1. I wanted when the first page (1) Open then after 5 mins. the frist page(1) will be close then the second page will be show/open.
basically for both pages the interval time to open/run is 5 mins.

2. I possible to fit into the screen the display using script.

The main objective is automate display the result of SSRS in an LCD monitor that can be viewed by workers.
The can see the data real time and they have to make a decision if there's an immidiate needs to work for the production output.

Or Do you have any idea? THank you in advance.

Please Login or Register  to view this content.

[pareshj]

Hi,

You can add the following code to open second page after specified time :

Please Login or Register  to view this content.

This is sample code, you need to change it as per your requirement.
And to change the URL of the SSRS link, keep it in the Do while Loop

Like this :

Please Login or Register  to view this content.

where you need to increment the value of i and then apply .wait function



Regards,
Paresh J

[Jovillanueva]

Hi Paresh J,

I tried to insert the google.com based on the codes you have given but its not working.

i wanted to run first the yahoo then let say 5 minutes then after 5 minutes i wanted to run the google.. vice versa...

[pareshj]

Hi,

If only two sites you want to check after 5 mins then what you can is, check the following code:

Please Login or Register  to view this content.

Regards,
Paresh J

[Jovillanueva]

Hi Paresh J,

Try to run the codes you have given, I encounter an error. Please see modified scripts. maybe i have a missing codes.

Please Login or Register  to view this content.

[pareshj]

Hi,

Try this code:

Please Login or Register  to view this content.

Note : If you dont want to continue do while loop for long to can break and come out of it.
Like below:

Please Login or Register  to view this content.

Put this code inside do while in elseif part.


Regards,
Paresh J

[Jovillanueva]

Hi Paresh J, thank you very much for your prompt reply.

Compile the code to .vbs script and run through task manager to repeatedly run the codes for every 15 minutes (for testing).
Basically it should run the codes 5 minutes for yahoo and then after 5 minutes the google will come up. therefor, upon testing the first URL come up is yahoo, i'm waiting for almost 6 mis. the google did not come up. Then try to put a msgbox after the application wait, then clicking the message box the google come out.

btw, is possible to run simultaneously both the URL then automate the tab that should be open. just another idea if its doable. thank you.