Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Is there an alternative to Sendkeys for the Mac? - REALLY NE

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On a PC you can use the SendKeys function, is there an alternative to this for applemac? I need to switch from one workbook to another (by using the Alt+Tab keys) is there any way to do this on a mac?

    [ This Message was edited by: willlobb on 2002-04-04 04:08 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know if this is possible?

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you know the names of the open workbooks?

    Thisworkbook.Activate
    Workbook("name.xls").Activate

    should do what you want rather than using SendKeys.

    Regards,
    Jay

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The name depends on the value of a cell. It opens OK. eg, it opens "Transactions For Week " & Range("Week1Date"), but then i need it to switch between that workbook and another one that is open. Also, i have an email macro, and it uses the shortcut key Alt+S (send in outlook express)to send the emails, how would i be able to do this? Is it possible?
    Thanks
    Will

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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