Turn off save confirmation for excel in VB6
Posted on 2002-05-01
I've a VB program that populates an Excel sheet, prints it out, then closes it.
Every time it closes it's asking if I want to save my changes, which is always No.
How can I turn off the save confirmation and just have it dump the changes when it quits? It's VB controlling all of this, or if theres a way to turn it off just inside that 1 file, but I dont want a global change for all of Excel... just when I'm using this file.