Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Question Unanswered: Call up excell workbook from with DB through on Click

    I am so new to DB and have worked really hard to get where I am, I might be asking the most stupid question but:

    Is it possible to insert an excel workbook into a DB which could be opened by on click, the information could be held out side the DB, this which would get over my problem of multiple appointments. If I could have a 12 sheets workbook each representing a month, then month dates in col A, times in col B and then the individule technicians in col beside the dates. Could this be done by maybe a Hypelink, as I say I might be asking the rediculous but hay I can only ask

    Thanks Cheryl

    I have found this as below but how do I direct it to a specific workbook

    Private Sub Command10_Click()
    On Error GoTo Err_Command10_Click

    Dim oApp As Object

    Set oApp = CreateObject("Excel.Application")
    oApp.Visible = True
    'Only XL 97 supports UserControl Property
    On Error Resume Next
    oApp.UserControl = True

    Exit Sub

    MsgBox Err.Description
    Resume Exit_Command10_Click

    End Sub
    Last edited by cheryl_uk; 09-18-09 at 15:11.

  2. #2
    Join Date
    May 2009

    Use oApp.Workbooks.Open


Posting Permissions

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