Auto-refresh an image inside a spread sheet every 19 seconds

Have live data feeds that link to a server upstairs in the control room that display on custom control screens. Every 19 seconds a new screen capture taken and over writes an images on the network hard drive. This information is extreme vital. i want to embed these images into my dashboard but they need to be refreshed every 19 seconds. What kind script do i need to have it refresh in the background?


the Mucbean

Something like this might get you started

Please Login or Register  to view this content.

thanks i will add it in see how we make out . I'm assuming i'll need to make that image an active x control as its LAN hyperlink as well

Give it a try and see which way works best.

I've used this to capture sample images off vision systems over IP and it worked fine.

Ant seem to get it to work, the file is a png file, Excell doesn't recongnize it for some reason ..

Originally Posted by mucbeanz

Ant seem to get it to work, the file is a png file, Excell doesn't recongnize it for some reason ..

I use .png images in excel regularly.
How did you insert the image originally?

just insert the photo, I'm assuming i should've used an activex insert instead linking that code to it?

I just ran this and it worked without error

Try setting the path to your image

Please Login or Register  to view this content.

@ihmha I will try that once i get to work. Sure would be pretty cool to pull this off. Those 2 images are absolutely critical or our shop area, an unfortunately you need to goto a computer to view the screen. Theres a good chance i could have this new dashboard displayed on one of the 70" screen out on the floor. So surprised no one has ventured down this road before esp the size the the company i work for. Thanks for your help on this! I will let yo know how it turns out. The second image refreshes every 30 seconds, which is pretty easy change. Logically the code makes perfect sense esp the delete and new insert function Will let you know how it turns out.

cheers mucbeanz

so i tried it a few times at work the first time i crashed excel into not responding. . made some adjustments then tried the activex picture had the control present but the image wouldn't show however after 9 seconds the active control disappeared. the image is actually a web address (LAN) not sure whether that makes a difference. but i was unable to get it working

Originally Posted by Keebellah

Hi, just curious, have you been able to solve this?
I was wondering if you can still work with the file while the timer is running.
I use the Application.OnTime construction you have macros run at specific intervals and in the mean time I can still work in that file and it works in the background, you just have to make sure the timers are stopped before closing Excel. The images shouldn't be a problem
Will the image always have the same name?

I have never had any problems with working whilst this is running in the background.
The timer function uses the inbuilt timer, and as you are only checking the value every scan you can run the other code as normal.

Originally Posted by mucbeanz

@ihmha I will try that once i get to work. Sure would be pretty cool to pull this off. Those 2 images are absolutely critical or our shop area, an unfortunately you need to goto a computer to view the screen. Theres a good chance i could have this new dashboard displayed on one of the 70" screen out on the floor. So surprised no one has ventured down this road before esp the size the the company i work for. Thanks for your help on this! I will let yo know how it turns out. The second image refreshes every 30 seconds, which is pretty easy change. Logically the code makes perfect sense esp the delete and new insert function Will let you know how it turns out.

cheers mucbeanz

Use two dblTimer (dblTimer_1 and dblTimer_2) values and make them separate loops and time intervals

Originally Posted by mucbeanz

so i tried it a few times at work the first time i crashed excel into not responding. . made some adjustments then tried the activex picture had the control present but the image wouldn't show however after 9 seconds the active control disappeared. the image is actually a web address (LAN) not sure whether that makes a difference. but i was unable to get it working

The web address will make a difference.
I think you need to use a hyperlink, and do a refresh and not a delete.
Although I've never tried it so I hope someone else has experience in this area and throws some help in.

Originally Posted by Keebellah

Do you get any error message?
I think it's the way the timer is set.

The timer is the real time clock built into Windows, all the code does is sample the timer and use it for the compare in order to run the code inbetween.

Ok awesome, I will try again tomorrow when I back into work. It makes sense what your saying I wondering mostly though whether I embedded that image correctly will do what you mentioned and get back to you thank you!