Swap their 5250 client for one that does not "talk/respond" to Excel or use system policies to disable VBA in Office. The former has the potential problem that most 5250 clients provide some manner of scripting (but at least they'd have to learn a new way of doing things and hopefully it's harder) and the latter can have a major negative impact on the utility of Office in your organization. I wouldn't rate either as an optimal choice, but both should be effective.
coy
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kirk Goins
Sent: Monday, April 29, 2013 14:46
To: Midrange-L
Subject: Excel Macro doing mass Input via GreenScreen
I am still digging for exact details, but I received a call this afternoon from a concerned IT Manager. He has heard of some users using Excel and Macro's to do larger numbers of data entries via standard greenscreen sessions. I assume they are populating a spreadsheet from an external source and then running the macro to run the greescreen input. Anyone seen this before? Can you stop it by A. Tasering the user(s) B. Using a Group Policy to block ALL Macro Use within Excel ( this seems a little extreme) C. ??
I am not looking for better or different ways to do this, looking to stop this method.
Thanks
--
Kirk
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
************************************************************************
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or taking any action based on it, is strictly prohibited.
***********************************************************************
midrange.com
