Re: Excel Macro doing mass Input via GreenScreen

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

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