Re: Excel Macro doing mass Input via GreenScreen

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.