Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Defaults in VBA
When saving a document using VBA it would always default
to either saving with changes or without (as an example) What do I enter into the code that would force it into doing otherwise? Many thanks in advance John |
#2
|
|||
|
|||
If I am not mistaken, when you "save" a document, the changes will be saved.
However, when you "close" a document, you have the option of saving changes or not. Workbooks("BOOK1.XLS").Close SaveChanges:=False ' or True You may want to look at the "Saved" property also. You can fake excel into thinking the workbook was saved, then close it. ThisWorkbook.Saved = True ThisWorkbook.Close I hope I understood the question correctly. -- Dana DeLouis Win XP & Office 2003 "JohnUK" wrote in message ... When saving a document using VBA it would always default to either saving with changes or without (as an example) What do I enter into the code that would force it into doing otherwise? Many thanks in advance John |
#3
|
|||
|
|||
Thanks Dana, I will give this a go. The problem I have is
that a few of my workbooks run macro's automaticaly when opened, and because i am working on a project that brings in 12 workbooks information into one, I dont want them to save the changes, hence the wanting to change the defaults. I am sure this would also help me in other projects also. Many thanks again John -----Original Message----- If I am not mistaken, when you "save" a document, the changes will be saved. However, when you "close" a document, you have the option of saving changes or not. Workbooks("BOOK1.XLS").Close SaveChanges:=False ' or True You may want to look at the "Saved" property also. You can fake excel into thinking the workbook was saved, then close it. ThisWorkbook.Saved = True ThisWorkbook.Close I hope I understood the question correctly. -- Dana DeLouis Win XP & Office 2003 "JohnUK" wrote in message ... When saving a document using VBA it would always default to either saving with changes or without (as an example) What do I enter into the code that would force it into doing otherwise? Many thanks in advance John . |
#4
|
|||
|
|||
Just throwing out an idea. If you open certain workbooks often, and know
that you do not want to save changes, perhaps add something like this to the "ThisWorkbook" module: Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub When this workbook is closed, Excel will think that the data has been saved, and won't prompt to save anything. Another option to throw out. In Personal.xls, I have a class module that intercepts the closing of all workbooks. If the workbook has a certain document property set, the macro will set the saved property to true. For example, a certain template imports data, and generates reports, When I click close, I do not want this saved (I would run the macro again for more current data). I would add a document property to this template that tells the closing macro not to bother saving changes. Again, just an idea. -- Dana DeLouis Win XP & Office 2003 "JohnUK" wrote in message ... Thanks Dana, I will give this a go. The problem I have is that a few of my workbooks run macro's automaticaly when opened, and because i am working on a project that brings in 12 workbooks information into one, I dont want them to save the changes, hence the wanting to change the defaults. I am sure this would also help me in other projects also. Many thanks again John -----Original Message----- If I am not mistaken, when you "save" a document, the changes will be saved. However, when you "close" a document, you have the option of saving changes or not. Workbooks("BOOK1.XLS").Close SaveChanges:=False ' or True You may want to look at the "Saved" property also. You can fake excel into thinking the workbook was saved, then close it. ThisWorkbook.Saved = True ThisWorkbook.Close I hope I understood the question correctly. -- Dana DeLouis Win XP & Office 2003 "JohnUK" wrote in message ... When saving a document using VBA it would always default to either saving with changes or without (as an example) What do I enter into the code that would force it into doing otherwise? Many thanks in advance John . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I entered 11/22/2004 in excel workbook and it keeps changing to ## | Excel Worksheet Functions | |||
How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) | |||
Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
Changing Dates in Excel | Excel Worksheet Functions | |||
How can I change size of the picture without changing chartobject? | Charts and Charting in Excel |