Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where the Excel template is at (Excel 2000)

    Is there a way to tell where an instance of the Excel workbook is from. In other words when I create a Workbook (xls) from an Excel template can I figure out where the template that it was derived from?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Where the Excel template is at (Excel 2000)

    Unless you write code to store information about the template in the workbook (for example as a custom document property), no. Excel is different from Word, a workbook has no connection whatsoever to the template it was created from. The workbook is a complete, independent copy of the template.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where the Excel template is at (Excel 2000)

    How about the first time that the workbook instance is derived from a template before it is saved as a xls?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Where the Excel template is at (Excel 2000)

    The only thing that comes to mind is the name of the workbook - before it has been saved, it is the name of the template, minus the extension, plus a sequential number: if you create a workbook based on MyTemplate.xlt, the name will be MyTemplate1 (or MyTemplate2 etc.) You could use this name to do a file search...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •