Turn off save confirmation for excel in VB6

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.

Anyone?
LVL 2
edskeeAsked:
Who is Participating?
 
Anne TroyConnect With a Mentor East Coast ManagerCommented:
On the Workbook Before Close, put:

Workbook.Saved = True

0
 
edskeeAuthor Commented:
Thank you much!
0
 
Anne TroyEast Coast ManagerCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.