+ Reply to Thread
Results 1 to 1 of 1

Macro to hit Ok button or Enter command to an external application

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    Pune
    MS-Off Ver
    Excel 2007
    Posts
    3

    Angry Macro to hit Ok button or Enter command to an external application

    Macro to hit Ok button or Enter command to an external application
    SendKeys Onkeys are not working
    Is there a way through vba I can hit OK or press enter in an external app?

    Sub GetBOData()
    Dim BOApp As Object
    On Error Resume Next
    Set BOApp = CreateObject("BusinessObjects.application")
    With BOApp
    .Visible = True
    .LoginAs "aaaaa", "Xxxxx"

    <Enter needs to be pressed here>

    .Documents.Open ("C:\Users\abhpatil\Documents\My Business Objects Documents\userDocs\Test.rep")
    With .ActiveDocument.Refresh
    End With
    End With
    Set BOApp = Nothing
    Set BODoc = Nothing
    End Sub
    Last edited by paidlukkha; 09-16-2014 at 12:13 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Launch application by command button on excel vba userform
    By Benjamin2008 in forum Excel General
    Replies: 1
    Last Post: 12-20-2013, 05:15 PM
  2. Replies: 2
    Last Post: 07-13-2013, 01:10 AM
  3. Press command button to enter date
    By Jr66 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2013, 06:09 PM
  4. [Solved] Command Button to enter number in other field
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 08:51 AM
  5. Command button auto select after pressing Enter
    By Bafa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2006, 03:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1