Results 1 to 2 of 2

Closing application before MsgBox appears.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Question Closing application before MsgBox appears.

    Good Morning.
    Currently I have a macro that opens access and imports my table from some excel spreadsheets. After it is done I have a MsgBox pop up stating that update is complete. However, Access stays open and you cant see the Msg Box until you click back to excel. What can I do to have Access Close before the MsgBox appears.

    Dim oApp As Object
    
        Dim LPath As String
        
        LPath = "c:\\Penetration Database\penetrationdata.mdb"
    
        Set oApp = CreateObject("Access.Application")
        
        oApp.Visible = True
        
        oApp.OpenCurrentDatabase LPath
    
        oApp.DoCmd.RunMacro "imcampdata"
      
        MsgBox "Update Complete"
    Last edited by CJPHX; 05-26-2010 at 01:13 PM.

Thread Information

Users Browsing this Thread

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

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