Solved

Turn off save confirmation for excel in VB6

Posted on 2002-05-01
3
166 Views
Last Modified: 2008-01-09
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?
0
Comment
Question by:edskee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
Dreamboat earned 50 total points
ID: 6984297
On the Workbook Before Close, put:

Workbook.Saved = True

0
 
LVL 2

Author Comment

by:edskee
ID: 6984325
Thank you much!
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6984396
:)
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question