Solved

Turn off save confirmation for excel in VB6

Posted on 2002-05-01
3
161 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
  • 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
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…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now