Is it possible to programmatically "Save with thumbnail"?

Hi.

At work we use an Excel document to record data on individual jobs through our system. We currently do this with paper, and part of the printed document set is a "summary top-sheet" that outlines the full page(s) below.

I'd like to take this process and do it with Excel files, and have proved I can create the "Summary" tab in such a way so that - as long as my Excel is set up to "Save every spreadsheet with thumbnail" - I can clearly read the Summary in a folder set to display with "Extra-large icons".

The thing is, I don't really want to save every spreadsheet with a thumbnail! I'd like to find a way so that I could use a bit of VB code to save the document AND create its thumbnail at the same time. That way I can control when image are / are not saved.

I've done some trawling and Googling but not been able to find anything relevant... I will continue looking, but if anyone can shed any light on this I would be very grateful.

Cheers

Skotzmun

Hi,

don't think it's doable 'cause DocumentProperties are read-only
and after activating it via the check box in a workbook properties using the Macro recorder,
the generated code is empty …