#1   Report Post  
Old March 22nd 08, 02:48 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 5
Default preview all files

Set ALL files to show a preview as in thumbnails, at once.

  #2   Report Post  
Old March 22nd 08, 06:36 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default preview all files

Cannot be done.

Each workbook must be individually saved with that attribute checked under
FilePropertiesSummary tabSave Preview Picture.

Unless you want code to loop through all workbooks in a folder, open them, set
the attribute then save/close.

I don't think I could help you much with that.

I don't know how to set the Save Preview Picture attribute.


Gord Dibben MS Excel MVP



On Sat, 22 Mar 2008 07:48:00 -0700, sussertown
wrote:

Set ALL files to show a preview as in thumbnails, at once.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
set Print Preview to "preview" page that was being worked on? ACULAK Excel Discussion (Misc queries) 0 October 5th 07 02:06 AM
Preview Excel Files lbj595 Excel Discussion (Misc queries) 5 May 12th 07 02:21 PM
print preview v page break preview SamB Excel Discussion (Misc queries) 0 November 16th 06 05:09 PM
How do I preview my Excel files before opening them? silverthorn1999 Excel Discussion (Misc queries) 1 July 13th 05 06:56 PM
Wish to apply "Save Preview Picture" in 300 files. Carolyn Crandall Excel Discussion (Misc queries) 0 March 30th 05 09:09 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017