Wish to apply "Save Preview Picture" in 300 files.

[Jim May]

I've created 300 files none of which show in the "preview-screen" when I
do a File Open. The setting of course is in the File Properties, Summay Tab
(chk box at bottom); I tried via Record-Macro, but no results; Any ideas as
to how to Loop thru complete Folder (containing the 300 and apply this
setting)?
Tks in Advance..

 

[Ron de Bruin]

Hi Jim

As far as I know it is not possible with code

This is old post from Bill Manville to turn it of

Sub NoPreviewPic()
SendKeys "^{PGUP}^{HOME}^{PGDN}+{TAB}+{TAB}+{TAB}-{TAB}{ENTER}"
Application.Dialogs(xlDialogProperties).Show
End Sub

 

[Jim May]

Thanks Ron;
Jim

 

[Guest]

I have the same issue in 2003. Did you ever get any answers..... thanks