On Mon, 10 Aug 2009 03:29:02 -0700, Joel
wrote:

Instead, just open a one sheet workbook that contains your formating. You
can open it in Read mode so it doesn't get changed. Then use SAVEAS to
change the file to a different name.

Thanks, but as I said...

****I'm aware that there are ways to work around this for your own
application****, but we use an external application which generates single
sheet files (presumably) using the above method and it is ANNOYING to
have to merge our standard styles into them.

"Hank Scorpio" wrote:

This has been bugging me all day.

If you save a template named book.xlt in your xlStart folder, then any
new standard workbooks will inherit the styles and formatting of that
template.

That's fine.

If you save a single sheet template named sheet.xls, then any new
worksheet that is added to an existing workbook will inherit the
styles and formatting of that template sheet.

That's fine too.

But for the life of me, I cannot find any way to create a template
which will apply if you create a single sheet workbook using the

Application.Workbooks.Add(xlWBATWorksheet)

method. It doesn't use book.xlt's, it doesn't use sheet.xlts, and I
cannot find ANYWHERE that suggests whether it can use a template and
if so, what that template should be named. (Nor have I fluked the
discovery of that through trial and error.)

I couldn't find anything through web searches, and unfortunately
Google has so comprehensively cactused the newsgroup search engine
that it's impossible to find anything there either.

I'm aware that there are ways to work around this for your own
application, but we use an external application which generates single
sheet files (presumably) using the above method and it is ANNOYING to
have to merge our standard styles into them.

Does anyone have any thoughts?


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is {Between permanent e-mail addresses at this time, which makes the next line of my signature redundant}
* Please keep all replies in this Newsgroup. Thanks! *