Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    5

    Unanswered: VBA code for Inserting an Excel sheet

    Hi everyone. I think this question is pretty simple, and would appreciate any help offered.

    I have a bound OLE field setup, and can use the Insert menu to insert an Excel sheet into the field, but I would like to setup a function so that my users only need to click on a button to insert the OLE object. The Insert menu thing will freak them out.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Easy

    TransferSpreadSheet or you can use the linked Table method!

    What's hard is reading individual worksheets in a SS.

    DBS4M

Posting Permissions

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