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

Anyone know how to send keys when pc is locked ?????
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Sendkeys

I believe the pc must be unlocked in order for SendKeys to work. What are
you trying to do? (possibly a way to do it without SendKeys)

" wrote:

Anyone know how to send keys when pc is locked ?????

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Sendkeys

On 27 Sep, 04:58, AndyM wrote:
I believe the pc must be unlocked in order for SendKeys to work. *What are
you trying to do? *(possibly a way to do it without SendKeys)

" wrote:
Anyone know how to send keys when pc is locked ?????


I have built a macro to open a ie url, open a form & download a text
file, I need send keys to save down this text file
which only works on a unlocked pc any ideas ? batch files do the same
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Sendkeys

Try opening your ie url, open your form, then getting the full URL of the
text file you are trying to download. Then you can use a separate function
to download the file without using SendKeys. You can find this function at:
http://vbaexpress.com/kb/getarticle.php?kb_id=799

Since this doesn't use SendKeys, it will work even if the computer is locked.

Can you post a link to your site or is it internal only?

"wazzo" wrote:

On 27 Sep, 04:58, AndyM wrote:
I believe the pc must be unlocked in order for SendKeys to work. What are
you trying to do? (possibly a way to do it without SendKeys)

" wrote:
Anyone know how to send keys when pc is locked ?????


I have built a macro to open a ie url, open a form & download a text
file, I need send keys to save down this text file
which only works on a unlocked pc any ideas ? batch files do the same

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
SendKeys Help ankur Excel Programming 2 January 17th 07 11:25 AM
SendKeys [email protected] Excel Programming 1 July 25th 05 06:05 PM
SendKeys? CMK Excel Programming 2 February 23rd 05 12:03 AM
Sendkeys GB[_3_] Excel Programming 0 September 16th 03 10:39 PM
SendKeys Ron de Bruin Excel Programming 3 August 25th 03 10:21 PM


All times are GMT +1. The time now is 02:30 AM.

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

About Us

"It's about Microsoft Excel"