Quitting excel without saving message???

[Phailak]

Hail,

I'm kind of new to VBA so here goes...
I just want to quit excel application after having printed the data I pasted there. Now when I call xlSheet.quit, it prompts the user to save Yes, no or cancel but I don't want that message since the user never sees excel in the first place.
Any help?

Phailak

 

[dsi]

Try this:

Application.DisplayAlerts = False
Application.Quit

Hope this helps!

 

[Store300]

Alternatively you can use:

ActiveWorkbook.Saved = True

This will make Excel think that the workbook has already been saved and so it doesn't ask the question.

 

[LoNeRaVeR]

Store300:

When all else fails we can always trick Excel into thinking only what we want it to think. ;-)

A very original idea! I'll remember that one.

Regards,

LoNeRaVeR

 

[Store300]

LoNeRaVeR:

Thank you

 

[Phailak]

Thanx guys

Phailak