Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Close XLS

Status
Not open for further replies.
Joined
Mar 26, 2004
Messages
19
Location
GB
Hello,

What I'm trying to do is when a workbook is opened a check will be performed and if it fails the workbook will close without saving.

It's the closing without saving I'm struggling with...?

Thanks
 
Activeworkbook.saved=true
Application.quit
 
Activeworkbook.close(false)

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top