Changing Defaults in VBA

J

JohnUK

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
 
D

Dana DeLouis

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.
 
J

JohnUK

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
 
D

Dana DeLouis

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.
 
Top