LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default API commands and personal liability in a corporate business?

This is a rather different question then what's normally asked on
these boards... I need some advice regarding API commands and personal
liability...I work for a company that will go unnamed in this message.
I have been proposing a method using Excel / VBA to speed up a process
up that currently takes way to freaking long to do with the company I
work for. My boss has agreed for the production of this new custom
designed software and has supported it from day one... I have figured
out how to get the process much faster using VBA and Excel...The
method we use now is semi-flawless, unless its 'fat fingered' or the
normal human mistakes, because its done by hand. My new method which
could do 1000 updates in less then 5 minutes versus a 1000 updates
taking about three weeks to complete...errors can still happen with
entering the information on my application but its unlikely it could
happen. However there is a problem... In order for my process to work
correctly and completely I require that the end-user does not
interrupt the process as it could effect millions of dollars worth of
inventory as Excel is altering information inside of another system in
real time... (Please do not ask how I managed to get this to work as I
will not share the code; as its corporate property not mine), so I
have decided to use an API command to shut off the keyboard and mouse
during the update process. Now I could display a message saying
"Please do not interrupt this process!" but I need the comfort of
being able to sleep at night knowing that a end-user in my department
won't crash the system by stopping my application prematurely because
they want to check their e-mail...which is why I have decided to
include this API command in the applications process to kill the
keyboard and mouse until the macro is over with.

My question is how would you go about recommending the
'enhancement' (API command to kill keyboard and mouse temporarily) in
a business when it could be looked at through a different light as a
malicious piece of code (virus)? This enhancement makes sense to me,
as the developer and team leader of the department, but I don't know
how it would look to the IT department (security) inside of the
company...any suggestions?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Excel VBA corporate with MSN Alerts? jazzcarr Excel Discussion (Misc queries) 0 January 1st 08 12:37 PM
Copy and paste to corporate sheet Marie Excel Programming 9 January 13th 07 03:49 PM
Subtotal by Account (cash, liability, revenue, expense) in Excel? Shay Excel Worksheet Functions 2 September 15th 06 06:02 PM
Corporate Error Reporting with DW.exe John.Greenan Excel Programming 0 June 14th 06 02:17 PM
Import from corporate databases Billy B Excel Discussion (Misc queries) 0 February 2nd 05 04:35 PM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"