Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Help Help Help Help!!!!!


Hi, not sure if this is possible, but if it is then you are a
genuis!!!!!!

We've got this system at work where we have to log in, though there is
a maximum of 40 users, so no more people can get in. However, if you
have the time, and can be bothered, if you hold down the enter key for
about an hour, if someone in that time logs out or turns their pc off
then you can take their space. Im quite sure nothing can be down whilst
im using other programs on my comp, though would it be possible to run
some sort of macro/program where if i was to go on break, it would keep
hitting the OK button to login - contsantly, until i stopped it??????

If someone can do this - then you have saved me hours of button
bashing!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=506713

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default Help Help Help Help!!!!!

The only "standard" VBA that might be able to do this would be to repeatedly
AppActivate the app and use SendKeys to send an {ENTER} (assuming focus is
already on the "OK" button) - but this would require actually giving the
application focus and would interfere with anything else you might be doing;
plus AppActivate with SendKeys is problematic if other applications are
running that can "steal" the focus. Or you could try similar things using
the Windows API that might be able to directly address the window that
contains the button, without the need to give the focus to the application.
But I would not recommend trying either of these. It would be easier to
leave your coffee mug on the enter key!

Seriously, the only "real" solution is that your company needs more user
licenses. Any workaround is potentially problematic and does not solve the
real problem.

--
- K Dales


"stapleton2308" wrote:


Hi, not sure if this is possible, but if it is then you are a
genuis!!!!!!

We've got this system at work where we have to log in, though there is
a maximum of 40 users, so no more people can get in. However, if you
have the time, and can be bothered, if you hold down the enter key for
about an hour, if someone in that time logs out or turns their pc off
then you can take their space. Im quite sure nothing can be down whilst
im using other programs on my comp, though would it be possible to run
some sort of macro/program where if i was to go on break, it would keep
hitting the OK button to login - contsantly, until i stopped it??????

If someone can do this - then you have saved me hours of button
bashing!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=506713


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Help Help Help Help!!!!!


fair enough mate - didn't think it was really possible - many thank
anywa

--
stapleton230
-----------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...fo&userid=3087
View this thread: http://www.excelforum.com/showthread.php?threadid=50671

Reply
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



All times are GMT +1. The time now is 09:47 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"