I am trying to find a way to run Excel macros via BWS. The Case: BWS runs 4 reference lab reports and saves them on a network drive. I then use Excel to combine these 4 reports into 2 and remove the garbage, etc... Unfortunately my off network pc had a catastrophic HDD failure and is now offline. Since I don't want to go through that again I've gotten access to a virtual system on the network. Unfortunately the admins have excel macro security set to medium and needs user permission to run. I've added the libraries to BWS and can run most of the macro via BWS, but fails on Excel VBA only terms (like Row.count). Has anyone already come up with a solution to something like this or any ideas how to go about coming up with a solution?
Thanks. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [email protected] ________________________________ CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender at the electronic mail address noted above and destroy all copies of this communication and any attachments. Thank you for your cooperation. --- 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
