Results 1 to 4 of 4

Thread: macros language help ?

  1. #1
    VBAX Contributor
    Joined
    Jun 2008
    Posts
    169
    Location

    macros language help ?

    Dear?s all

    As I understanding the Macros Language of (.Sendkey ?@1?) = keyboards function key?F1? and (.Sendkey ?@2?) = function key F2 ?etc? now I have problems and query today I had going to toing yo y. specify the language needorks, hey the F10 can'he modual ry made the modules and that's one particular of the Macros language to call (.sendkey ?@10?), somehow' that?s can't be work with going to activate the keyboard key ?F1???? why


    Anyone can help me why on at which parts I made a wrong? I had try the key of F11 / F12 also works, hey the F10 can?t be or any specify the language needs an identify.?



    Pleased experts help

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Sendkeys should be avoided if possible.

    To send F10:
    Sub test()
      Application.SendKeys "{F10}", True
    End Sub

  3. #3
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    Sendkeys should be avoided if possible.
    To explain this: SendKeys can be a very large pain in the butt, mainly because the keystrokes are sent to whatever has the focus... so if another program pops up while your macro is running, the keystrokes could go the the wrong place.

    Also, there is a security risk, as a malicious user could intercept your sendkeys and 'steal' your data that way.

    They definately have their places, and their uses, but they can be a liability. If you want more information/opinions on Sendkeys, you can google the subject.

    HTH
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


  4. #4
    VBAX Contributor
    Joined
    Jun 2008
    Posts
    169
    Location
    All brother's

    I get understood
    Thanks the help and advise,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •