Save an image file of the print area on each worksheet

I currently have one workbook with about 20 worksheets. Each worksheet has its own data connection to our database.

I'd like to have a VBA code wrote that refreshes all 20 data connections at once(refresh all), waits until the data is refreshed, then goes through each worksheet(20) and saves the print area of each worksheet as an image file to a specific location as the name of the tab. Pause for 15 minutes, repeats but then replaces the old image file(15 minutes ago) with the new image file in the specific location.

Thanks for your help!

First of all, I suggest making sure you have background refresh turned off for each of the data connections. Then look up copy as image and your paste options with that. Then instead of trying to do it every 15 minutes in Excel, use the windows task scheduler. You can schedule the task to run every 15 minutes and run your macros. This way the program stops running when it's not working. Also the task scheduler has a lot of built-in flexibility. You can even have it run while you're on vacation and deliver the images to a shared directory.

There are several ways to schedule a task. I do it on an industrial scale. What I do is create a script in Excel that creates a string you can copy and paste into the task manager. It works like this. The task manager runs the script which opens the target workbook and executes the macro you specified in the script. You can get a copy of a template script and a better explanation here: http://www.utteraccess.com/wiki/inde...a_Macro_to_Run.

Thanks for the reply and sorry for my delay. I'm having a guy look at your suggestion and see if we can make it work. We have mounted TV screens around the shop and wanting to display certain worksheets on each tv depending on the location they are in the shop. 1 TV will (slideshow/display) 3 certain worksheets, while a different tv will (slideshow/display)display 4 different worksheets. All these worksheets will be updated(every 15 minutes) throughout the day so the slideshow will be updated as the worksheets are updated via the data connection. Each separate tv will have its own computer that is accessing updated images from the main computer that has the excel file on it.

I have a feeling we will be figuring this out for a while before we get this up and running.(ha)

Thank you for your advice and sample files. We are working on this in the next couple weeks and if I have questions, I'll be in touch.

The data changes ever 15 minutes so we will be republishing every 15 minutes. Will Power Point re-read its data file automatically to capture the changes or do we have to do something in Power Point?

The data changes ever 15 minutes so we will be republishing every 15 minutes. Will Power Point re-read its data file automatically to capture the changes or do we have to do something in Power Point?

You would have to kick off the code that writes the powerpoint. You might have to close the instance of powerpoint and reopen it.

The way I'd do it is put the spreadsheet in the task scheduler to run a main macro that refreshes the data, then closes the existing instance of powerpoint, then create the new powerpoint from the template. I don't think you can update the powerpoint while it is running due to the file lock. Also I don't know how to detect if there is an instance of powerpoint running and shut it down.

Maybe this article will help:http://vbadud.blogspot.com/2007/04/g...-check-if.html

This code should shut it down

Please Login or Register  to view this content.