Re: Excel Macro doing mass Input via GreenScreen

Yes, it happens. Smart users have figured out a way to save themselves time, but applying "electronic fingers".

I'm not sure how you can shut it down from the iSeries side because I don't think it can tell the difference between read fingers and electronic fingers.

You might be able to remove the macro support from the Client Access side on the PC.

Is the concern valid? Is volume/speed of entry overwhelming the iSeries? Or is there the possibility that some control totals are being missed, or some validation errors are being ignored and inaccurate or incomplete data is being entered?

I suppose one way would be to periodically move a field or two on the screen and see if any of the macro break? Let them fix them, then move the field back a week later. Repeat as needed...

Or tasering might work.

Sam

(The really bad part is when they put in a request to help fix their macro. Do not get involved in that!)


On 4/29/2013 5:45 PM, Kirk Goins wrote:

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