Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: OLE Object Data Type

    I'm poking around in an old database (ACC97) that is still in use, but the original developer is no longer with the company.

    There is a field in one of the tables that is an OLE Object data type.
    When you look at the records, the field just says "Microsoft Excel Worksheet".
    If I double click the field, it opens the worksheet. Is there any way - with VBA - to tell what the filename for that worksheet is? I want to extract some data from it programatically.
    Inspiration Through Fermentation

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    There isn't a filename. The sheet is stored in the OLE object field, not in a file.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    very brave

    poking around in an Access 97 application that you didn't write, trying to work out how an ex-colleague's mind worked when developing stuff, and wanting to add new functionality.

    have you got no respect?, this app must be well into its twilight years, let it slumber in peace, treat it like the venerable app it is and tiptoe around don't disturb it, don't even admit to knowing whats in it just in case der boss demands you make changes and it becomes 'your' property

    rather you than me... Sir

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Quote Originally Posted by StarTrekker
    There isn't a filename. The sheet is stored in the OLE object field, not in a file.
    Ok, can I open that object programatically, and do I then have the Excel object model available to work with?
    Inspiration Through Fermentation

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by healdem
    very brave

    poking around in an Access 97 application that you didn't write, trying to work out how an ex-colleague's mind worked when developing stuff, and wanting to add new functionality....
    HA!! I do that all the time! ^^

    Quote Originally Posted by RedNeckGeek
    Ok, can I open that object programatically, and do I then have the Excel object model available to work with?
    TBH, I have no idea. I dodge OLE objects usage completely wherever I can... especially in Access 97 because of the mess it can make of your data file.

    What I would do it open each of the OLE objects and save them as files. Then put the path to those files in a field for the appropriate records.

    Other than that, all I can suggest is having a look at the help files for OLE objects and see what you can find out that way.

    Good luck!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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