View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TomP TomP is offline
external usenet poster
 
Posts: 27
Default Need Help Writing VB Code on a Template

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