/build/static/layout/Breadcrumb_cap_w.png

working on excel VBA, want to close a particular excel file (entire excel not workbook) without saving?

I have used "application.quit" but it closes all other excel files as well..please suggest how to close that particular excel file without saving and rest excel files will remain as it is.

Asked 11 years ago 1678 views
0 Comments   [ + ] Show comments

Answers (1)

Posted by: SMal.tmcc 11 years ago
Red Belt
0

did find this with a vbscript

http://www.pcreview.co.uk/forums/there-dos-command-close-excel-worksheet-t2213889.html

Comments:
  • Thanks but i want to use simple VBA code for that - appfreak 11 years ago
    • do not know VBA but will these help
      http://www.exceltip.com/st/Close_a_workbook_using_VBA_in_Microsoft_Excel/469.html
      http://www.ozgrid.com/forum/showthread.php?t=59208
      http://www.vbaexpress.com/kb/getarticle.php?kb_id=339 - SMal.tmcc 11 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ