View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Spreadsheet Solutions

Open a new workbook.

Format it any way you want.

FileSave AsFile Type "Template(*.XLT)"

Note: there are several workbooks in the Spreadsheet Solutions folder. Did
you have any particular one in mind?

Gord Dibben Excel MVP

On Tue, 15 Jun 2004 14:07:03 -0700, Perminant Template
wrote:

Is it possible to save a workbook in the same format as the 'Spreadsheet Solutions' area of Excel2002? If so, how do I save a template/worksheet in that format?