Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching off 'Save preview picture' in Excel
Hi!
Is it possible to swith off the option to save preview picture (File-Properties) with a macro? I'm automatically converting XLS files to HTML and if 'Save preview picture' is enabled, then WMF and filelist files are also created in a subfolder. I could of course simply delete those subfolders, but I usually convert a lot of files. Besides - I cannot simply detect the files that create subfolders at conversion for other reasons (eg. have data on several sheets). Thanks, Bostjan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching off 'Save preview picture' in Excel
Bostjan wrote:
Is it possible to swith off the option to save preview picture (File-Properties) with a macro? Better late than never? Sub NoPreviewPic() SendKeys "^{PGUP}^{HOME}^{PGDN}+{TAB}+{TAB}+{TAB}-{TAB}{ENTER}" Application.Dialogs(xlDialogProperties).Show End Sub Yuk! I've submitted a request for programmatic access to this setting. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Default to Save Preview Picture | Excel Discussion (Misc queries) | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
how to save file with preview in excel | New Users to Excel | |||
Wish to apply "Save Preview Picture" in 300 files. | Excel Discussion (Misc queries) | |||
How do I save a file in excel with a preview? | Excel Discussion (Misc queries) |