Re: Excel Macro doing mass Input via GreenScreen

[Kirk Goins <kirkgoins@xxxxxxxxx>]

I will re-post when I have more data.  You comment 'Why not as long as the
data gets scrubbed and validated before it hits the live system data ?' is
the concern. The belief is this data from Excel is being shoved through
standard data entry/update screens. So as long as there checks in the
input/update screens then they should be alright but there is a concern
expressed
.
More Data when I get it

Thanks everyone so far


On Mon, Apr 29, 2013 at 7:52 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

> Why don't you re-post more exact details once you know exactly what is
> happening and then we can offer ideas.
>
> I know of folks uploading transactions into JDE and other accounting
> systems via Excel.
>
> Why not as long as the data gets scrubbed and validated before it hits the
> live system data ?
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
> ------------------------------
>
> message: 6
> date: Mon, 29 Apr 2013 14:45:32 -0700
> from: Kirk Goins <kirkgoins@xxxxxxxxx>
> 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.