If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wish to apply "Save Preview Picture" in 300 files.
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.. |
#2
|
|||
|
|||
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 -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:SJW7d.12952$Hz.12671@fed1read04... 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.. |
#3
|
|||
|
|||
I have the same issue in 2003. Did you ever get any answers..... thanks
"Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:SJW7d.12952$Hz.12671@fed1read04... 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.. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
save a file with a preview | billy | General Discussion | 2 | September 16th, 2004 11:16 PM |
Will Office Picture Manager open PCX files? | flow2wolf | General Discussions | 1 | September 3rd, 2004 06:37 PM |
SP2 OE6 Newsgroups not showing picture preview | Mike T | Outlook Express | 5 | August 16th, 2004 08:35 PM |
files corrupted on save | Joe | New Users | 6 | May 17th, 2004 01:51 PM |
Save Excel file with preview in open file dialog box | Suzanne | Worksheet Functions | 2 | April 21st, 2004 05:15 PM |