Save in Preview

[Kelly Lum]

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

 

[Dave Peterson]

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

 

[bigwheel]

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

Hi Kelly

Click File, Properties and you will find a check box which will "Save
preview picture"

 

[Jim May]

Can this be done in VBA?
I just tried it using the macro recorded and got nothing...
maybe I'll try it again..
TIA,

 

[Dave Peterson]

It looks like you have to depend on Sendkeys--and that may not work in all
cases:

http://google.com/[email protected]
and
http://groups.google.com/groups?threadm=u8c3LsjuBHA.2692@tkmsftngp05

 

[Guest]

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

 

[Guest]

Will this work in 2003. I have several clients that have hundreds of files
that do not have the picture preview option checked. They are doing each one
individually.......

 

[Gord Dibben]

Carolyn

Dave's method works for all NEW workbooks.

Previously saved books must be done individually, although someone may come up
with some code to alter existing books.


Gord Dibben Excel MVP

 

[Dave Peterson]

I think that any code would have to use Sendkeys, too (which makes it
unreliable, well, for me anyway).