Why do you want to discard changes?

If the file is a true Tempate(*.xlt) a new workbook is opened based upon
that Template.

The Template itself does not open so is not changed in any manner.


Gord Dibben MS Excel MVP


On Wed, 5 Nov 2008 08:31:01 -0800, TomP
wrote:

When I open a template file and complete my entries, I would like to discard
all inputs made to that file and start over.

Question: Is there a way I can write a clode labeled "Reset" where Excel
will close and discard any changes to that file and reopens a new template
file?

For example... below I have a code written for MS Word and it works by
discarding the current file and reopens a new one. I just don't know how to
do it in MS Excel.

Dim LastDocument As Document
Set LastDocument = Active Document
OpenNewBlankDocument
LastDocument.Close SaveChanges:=wdDoNotSavechanges

Thank you,

Tom