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.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

did find this with a vbscript

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

Answered 02/22/2013 by: SMal.tmcc
Red Belt

  • Thanks but i want to use simple VBA code for that
    • 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
Please log in to comment
Answer this question or Comment on this question for clarity