Results 1 to 5 of 5

Thread: Create an access database by a VBA in Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    [Solved] Create an access database by a VBA in Excel

    Hi,

    I am looking to create an Access database from VBA in Excel. But I am unable to "create the database" and or open one if its already created. Here's the code I have so far. Any help?

    Option Explicit
    
    Public Sub sub_SendToAcces()
    
        Dim accApp As Access.Application
        Dim accDB As Object
        
        Set accApp = New Access.Application
        ' code to create a new database
        
        ' code to open it and set it in accDB variable
    
    End Sub
    Last edited by Blasphemer; 01-22-2009 at 12:52 AM.

Posting Permissions

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