Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How Excel VBA corporate with MSN Alerts? | Excel Discussion (Misc queries) | |||
Copy and paste to corporate sheet | Excel Programming | |||
Subtotal by Account (cash, liability, revenue, expense) in Excel? | Excel Worksheet Functions | |||
Corporate Error Reporting with DW.exe | Excel Programming | |||
Import from corporate databases | Excel Discussion (Misc queries) |