View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How can you startup an Excel Spreadsheet with a formatted templat.

Create a template named Book.xlt, and store it in the XLStart
folder, typically C:\Program Files\Microsoft
Office\Office\XLStart . This template will be used when creating
all new workbooks.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"David Tallahassee" <David
wrote in message
...
I wanted to know how can you start up an Excel Spreadsheet with
a Formatted
Template instead of the default worksheet which has no
formatting assign to
all columns.

Currently, I have created a formatted template and taking the
FTP
spreadsheet an successfully cut and pasted the FTP spreadsheet
into the
formatted template. I wanted to automate this process to bring
up the FTP
Spreadsheet into the formatted template. Is there away I can
add commands to
the FTP Spreadsheet to trigger the formatted template to
startup?

Please Advise.

David