Results 1 to 2 of 2

Thread: Sendkeys

  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Unanswered: Sendkeys

    Hi all,

    I would like to enable the "Trust access to vba project object model".(authorized on the application).
    I am trying to do this using using the sendkeys sub in excel 2007 since i think this is the only way to do it.
    Its working on windows vista, and the same code is not working on xp (the trust center window is displayed but no other action is performed). any advices, ideas?
    Thanks.
    Code:
    SendKeys "%T", True
    SendKeys "M", True
    SendKeys "S", True
    SendKeys "{TAB}", True
    SendKeys "{TAB}", True
    SendKeys " ", True
    SendKeys "{Enter}", True

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    This is an attempt to bypass a security feature of the Excel application. It is not exposed within the Excel object model for a reason. Get the user to do it manually.

Posting Permissions

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