Ryan,
Thanks for the example! It works perfectly. ===================== Thomas Xiao Patient Accounts / Systems Mercy Health System One West Elm Street Conshohocken, PA 19428 (610)567-6688 [EMAIL PROTECTED] ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 8:48 PM To: [email protected] Subject: [talkbws] RE: Run BWS using batch file and a VBA question For running a BWS script from a batch file, putting the below code into the batch file should work: :: Change to C:\ drive C: :: Call the BWS executable, passing the BWS project file and script name as parameters C:\Bss70\Bss80.exe <path and filename of script project file>/r <name of script in file to run> :: example: C:\Bss70\Bss80.exe C:\Bss70\Scripts\SampleScript.bws/r MyFirstScript Ryan Rush OBS Development Specialist Providence Health & Services Oregon RIS - Development 1235 NE 47th Ave #110 Portland, OR 97213 t: 503.215.4441 f: 503.215.4343 p: 503.604.6935 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 5:31 PM To: [email protected] Subject: [talkbws] RE: Run BWS using batch file and a VBA question I tried it. It didn't work. ===================== Thomas Xiao Patient Accounts / Systems Mercy Health System One West Elm Street Conshohocken, PA 19428 (610)567-6688 [EMAIL PROTECTED] ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 6:51 PM To: [email protected] Subject: [talkbws] RE: Run BWS using batch file and a VBA question 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 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 DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and 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 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
