| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save without changes
For example using this code:
Application.DisplayAlerts = False ActiveWorkbook.SaveAs " "filepath\filename"" Application.DisplayAlerts = True Will force the workbook to be saved without prompting from the user. What i want to do is close the ActiveWorkbook WITHOUT the changes an also without the Display prompts. The active workbook is called "EPLC.xls" and as there will be tw workbooks (or more) open i would rather, if possible refer to th "EPLC.xls" directly by name just to make sure nothing goes askew. TI -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save without changes
Hi Jako
ActiveWorkbook.Close False -- Regards Ron de Bruin http://www.rondebruin.nl "Jako " wrote in message ... For example using this code: Application.DisplayAlerts = False ActiveWorkbook.SaveAs " "filepath\filename"" Application.DisplayAlerts = True Will force the workbook to be saved without prompting from the user. What i want to do is close the ActiveWorkbook WITHOUT the changes and also without the Display prompts. The active workbook is called "EPLC.xls" and as there will be two workbooks (or more) open i would rather, if possible refer to the "EPLC.xls" directly by name just to make sure nothing goes askew. TIA --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save without changes
Try something like
ActiveWorkbook.Close savechanges:=False ' or Workbooks("EPLC.xls").Close savechanges:=False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jako " wrote in message ... For example using this code: Application.DisplayAlerts = False ActiveWorkbook.SaveAs " "filepath\filename"" Application.DisplayAlerts = True Will force the workbook to be saved without prompting from the user. What i want to do is close the ActiveWorkbook WITHOUT the changes and also without the Display prompts. The active workbook is called "EPLC.xls" and as there will be two workbooks (or more) open i would rather, if possible refer to the "EPLC.xls" directly by name just to make sure nothing goes askew. TIA --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
| Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
![Jako[_61_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
