So, how do you modify the default settings? If you create a new default
template [book.xls] like I have any settings you change , such as number
styles or fonts, only apply to a new workbook that you create.

Where the settings for a CSV or other textfile that you open directly
[without importing into an existing worksheet] come from I do not know and
cannot seem to find out. I was really hoping that someone from Microsoft
directly would answer this post, as I think that they will be able to provide
the information that I need.

Chris Bowers

I doubt very much if anyone from MS is monoitoring these news groups but if
they happened to see your post you would get same reply as I have given.

One more time................when you open a *.csv file directly, Excel will
use the default application workbook.

There is no way to alter that default workbook.

Creating a BOOK.XLT template only ensures that FileNew workbooks are based
upon that template.

That template will not be recognized when opening *.csv files.

My only and last suggestion is to create a macro in a new workbook to do
your formatting after the *.csv file is opened.

Save that workbook as an add-in which will load whenever Excel is opened.

Run that macro on the workbook created by the *.csv file.


Gord

On Mon, 15 Sep 2008 14:13:01 -0700, christopher.bowers
wrote:

So, how do you modify the default settings? If you create a new default
template [book.xls] like I have any settings you change , such as number
styles or fonts, only apply to a new workbook that you create.

Where the settings for a CSV or other textfile that you open directly
[without importing into an existing worksheet] come from I do not know and
cannot seem to find out. I was really hoping that someone from Microsoft
directly would answer this post, as I think that they will be able to provide
the information that I need.

Chris Bowers