Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Phoenix, AZ

    Unanswered: Get control of a Excel Spreadsheet from Access

    I am wonder if anyone knows a way to get control of a spreadsheet from Access and update it. I would like to update the spreadsheet by adding a tab and dumping some information and FORMATTING the data. I can get the database to transfer the data- simply enough but I need to be able to format the data within EXCEL. ANY IDEAS...

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    You'll have to use automation to really dig around in a worksheet. have a look at the Microsoft Excel 10.0 Object Library under references.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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