I have a sub I use in all my scripts that utilize Excel:
This keeps me from having to have the spreadsheet name change in each
script.
Sub WaitForExcelToShutDown()
Dim obj As Object
On Error GoTo trap
Do
Set obj = GetObject(, "Excel.Application") 'this will fail if
Excel Isnt running
obj.quit
Set obj = Nothing
Wait 2
Loop
Exit Sub
trap:
'we're in the clear
End Sub
Kim Scaccia, System Admin
Halifax Health
386-226-4590 opt 1 ext 2018
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2008 7:11 AM
To: [email protected]
Subject: [talkbws] RE: Run BWS using batch file and a VBA question
After saving, I use this code to close down my spreadsheets;
Windows("spreadsheetname.xls").Close
I date my spreadsheets in the name when saving so I modify the above to;
Windows("somename"& Format(Now, "mmddyy") & ".xls").Close
P.s. you might need one of these before the .Close statement, but I'm
not sure;
Windows("spreadsheetname.xls").Activate
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2008 7: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
---
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
---
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
