Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IS IT POSSIBLE IN EXCEL WITHOUT WRITING CODE. | Excel Worksheet Functions | |||
Need help writing Code | Excel Discussion (Misc queries) | |||
Writing and erasing code with code | Excel Programming | |||
Writing and reading from a template Excel file using ADO.Net - results not recalculated | Excel Programming | |||
Need some help writing code. | Excel Programming |