Greetings, You can run Excel macros directly from BWS -(with the same security caveats Brian described).
Open the spreadsheet using the DataStation, and then use the command: D.T.Appl.Run "MacroName" If your macros are fancy - meaning they accept parameters, you can still use them: D.T.Appl.Run "MacroName,Parm1,Parm1,..." You get up to 30 parameters which is quite generous, can't take any credit for it, that's a Microsoft thing. I've never seen a routine have even close to that many parameters. Would have been fun to be in the meeting when the maximum number of allowed parameters was discussed J Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Tuesday, June 30, 2009 9:20 AM To: Talk Subject: [talkbws] RE: Help getting Started Sometimes it seems the easiest solution is the most elusive. I've been outputting my NPR reports as generic files and then using Excel to reformat them into something useable and more easily interpreted for some time. I'm going to have to give Theresa's tip a shot. I've got one report that already has the delimiters defined but never put two and two together. You could run your report from MT to the screen and then scrape it off with BWS, but what a pain. You can use BWS to run the report(s), MS schedule to run excel (watch out for the macro security) to manipulate the data, and then BWS to email you the finished product on a daily basis. You could save the files to a folder, but an email is a great reminder that the job is finished or it failed if you get caught up doing something else. You can use BWS for your excel scripts, but I've yet to figure that one out, someday soon though. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 9:21 PM To: [email protected] Subject: [talkbws] RE: Help getting Started Or you can just add the delimiters in your NPR and use the delimited text file as input to your script. Theresa Palasota Senior Programmer/Analyst Georgetown Hospital System (843) 359-4092 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 8:05 PM To: [email protected] Subject: [talkbws] RE: Help getting Started The easiest way is to create a custom NPR that will output your data from Meditech in an "excel" format such as tabbed or comma separated format. Name your output with a .xls extension, and it will be useable as your data source from the outset. Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management : [email protected] <mailto:[email protected]> ________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 6:42 PM To: [email protected] Subject: [talkbws] Help getting Started I am new to BWS and have only written a couple scripts using an excel file to start. Now I want to move onto bigger/better projects. The first project I am trying to tackle is answering a query within BAR for a list of accounts that fail a specific claim check. I can run the failed claims report out of Meditech, import it into Excel, reformat the data into something readable, and then run the script from the excel file. The script itself is going to be easy and I get how to do that. The problem I am having is the work to run the report and reformat the data in Excel for the script to use takes longer than just doing the job. I guess the part I need help with is best practice recommendations for 'gathering' the source data from Meditech when it changes every day. Do you use BWS to run the report, import it into Excel, reformat the data, and then manipulate it however you need? Do you attempt to run the report in MT to screen and read off the screen of one session and work in another? Do you attempt to run the report in MT to the screen and read off the screen; move all the data off to variables in BWS and then work off that variable file? Other suggestions? Any pity and help is greatly appreciated. Thanks!! Amber Holcombe Applications Analyst, Patient Accounts Olympic Medical Center Phone: (360)417-7124 Fax: (360)417-7342 "Excellence is not a skill. It is an attitude." ~ Ralph Marston ------------------------------------------------------------------------- Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended individual(s) named above and may contain confidential, privileged, and/or protected information. Any unauthorized review, use, disclosure, copying, or distribution of its contents is prohibited. If you are not the intended recipient, you have received this email in error. If so, please notify the sender immediately by reply email and delete/destroy the original and all copies of this communication. Also know that Internet e-mail is not secure. In choosing to communicate with Olympic Medical Center by email you will assume these confidentiality risks. Internet messages may become corrupted, incomplete, or may incorrectly identify the sender. --- 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 NOTE: The information contained in this message may be privileged, confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer. Thank you. --- 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 ________________________________ 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 --- 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
<<image001.jpg>>
<<image002.jpg>>
