Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: Import data from Excel(VBA)

    Hi,

    I am trying to import data from excel spreadsheet to ms access table using VBA. My data is on random place( different cells) and I want to import it using VBA.

    Any help will be highly appreciated.

    Regads,
    mr_roomi

  2. #2
    Join Date
    Dec 2003
    Posts
    27
    Private Sub Command4_Click()
    Dim xWAp As New Excel.Application
    Dim xWSheet As New Excel.Worksheet

    xWAp.Workbooks.Open ("C:\Oleg\Book1.xls")
    Set xWSheet = xWAp.Worksheets(0)

    End Sub

  3. #3
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    import

    how can i get data from a perticular cell?
    mr_roomi

Posting Permissions

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