Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Excel Opening
I'm planning to put Excel on a few users' machines, but I want to set it up
in such a way that Excel won't open if they haven't met some external conditions. So they do the usual choice of things to fire up Excel.exe, but if the conditions aren't met, eg. outside office hours, then they get a message saying "XYZ Condition not met, etc. Try again later". I can see how to do this simply using a workbook containing VBa in XLStart, or perhaps using startup switch on Excel to open such workbook, but my wiley users would soon find this and delete it. Is there any way of doing something more robust, such as modifying a dll that would trigger my test (eg. a little exe file "conditionsmet.exe"), that if the condition wasn't met Excel would not open? Any ideas greatly appreciated, TIA, Dranz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Excel Opening
perhaps rename excel.exe to something else,
then set up a BAT file or other executable named excel.exe that would do what you want (including start excel if appropriate). -- Regards, Tom Ogilvy "Dransfield" wrote in message ... I'm planning to put Excel on a few users' machines, but I want to set it up in such a way that Excel won't open if they haven't met some external conditions. So they do the usual choice of things to fire up Excel.exe, but if the conditions aren't met, eg. outside office hours, then they get a message saying "XYZ Condition not met, etc. Try again later". I can see how to do this simply using a workbook containing VBa in XLStart, or perhaps using startup switch on Excel to open such workbook, but my wiley users would soon find this and delete it. Is there any way of doing something more robust, such as modifying a dll that would trigger my test (eg. a little exe file "conditionsmet.exe"), that if the condition wasn't met Excel would not open? Any ideas greatly appreciated, TIA, Dranz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Excel Opening
That's a good idea - do you know how I can stop the renamed Excel.exe having
the Excel icon, and make the new BAT file have the Excel icon? "Tom Ogilvy" wrote in message ... perhaps rename excel.exe to something else, then set up a BAT file or other executable named excel.exe that would do what you want (including start excel if appropriate). -- Regards, Tom Ogilvy "Dransfield" wrote in message ... I'm planning to put Excel on a few users' machines, but I want to set it up in such a way that Excel won't open if they haven't met some external conditions. So they do the usual choice of things to fire up Excel.exe, but if the conditions aren't met, eg. outside office hours, then they get a message saying "XYZ Condition not met, etc. Try again later". I can see how to do this simply using a workbook containing VBa in XLStart, or perhaps using startup switch on Excel to open such workbook, but my wiley users would soon find this and delete it. Is there any way of doing something more robust, such as modifying a dll that would trigger my test (eg. a little exe file "conditionsmet.exe"), that if the condition wasn't met Excel would not open? Any ideas greatly appreciated, TIA, Dranz |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Excel Opening
I don't. Maybe someone else does.
-- Regards, Tom Ogilvy "Dransfield" wrote in message ... That's a good idea - do you know how I can stop the renamed Excel.exe having the Excel icon, and make the new BAT file have the Excel icon? "Tom Ogilvy" wrote in message ... perhaps rename excel.exe to something else, then set up a BAT file or other executable named excel.exe that would do what you want (including start excel if appropriate). -- Regards, Tom Ogilvy "Dransfield" wrote in message ... I'm planning to put Excel on a few users' machines, but I want to set it up in such a way that Excel won't open if they haven't met some external conditions. So they do the usual choice of things to fire up Excel.exe, but if the conditions aren't met, eg. outside office hours, then they get a message saying "XYZ Condition not met, etc. Try again later". I can see how to do this simply using a workbook containing VBa in XLStart, or perhaps using startup switch on Excel to open such workbook, but my wiley users would soon find this and delete it. Is there any way of doing something more robust, such as modifying a dll that would trigger my test (eg. a little exe file "conditionsmet.exe"), that if the condition wasn't met Excel would not open? Any ideas greatly appreciated, TIA, Dranz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing excel insert/delete events. | Excel Worksheet Functions | |||
Capturing Insert/Delete Events in Excel Sheet using c# | Excel Worksheet Functions | |||
Capturing excel screenshots | Excel Discussion (Misc queries) | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
Capturing text in active cell to clipborad (Excel 95) | Excel Programming |