Would Application.Quit work?
Shirley Hammack I.T. Financial Analyst Duncan Regional Hospital 580-251-8939 From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 2:01 PM To: [email protected] Subject: [talkbws] Run BWS using batch file and a VBA question Good afternoon All, Can anyone show me how to run BWS using batch file? Also, I'm using the following code to close two excel files and excel application, but it keep opening a new workbook. Any ideas how I can close excel application? Application.DisplayAlerts = False ActiveWorkbook.close True ActiveWorkbook.close False ActiveWindow.close Many Thanks, Thomas ===================== Thomas Xiao Patient Accounts / Systems Mercy Health System One West Elm Street Conshohocken, PA 19428 (610)567-6688 [EMAIL PROTECTED] Confidentiality Notice: This email, including any attachments is the property of Catholic Health East and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please reply to the sender that you have received the message in error, then delete this message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [EMAIL PROTECTED] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx Please consider the environment before printing this e-mail. "CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are the property of DRH and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify 580.251.8773 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [EMAIL PROTECTED] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
