Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: Save and Close Excel Workbook with Access97

    I can open an Excel Workbook with Access97, is it possible to save and close it as well?
    Last edited by VaRaptor; 09-30-04 at 11:33.

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Dim xlsApp As Excel.Application
    Dim xlsWB As Excel.Workbook

    Set xlsApp = New Excel.Application
    Set xlsWB = Workbooks.Open(xlsPath)

    xlsWB.Close True 'Save
    xlsApp.Quit 'Close

Posting Permissions

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