Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing document properties (VBA for Office 97)

    I want to access document properties from Word, Excel and PPT documents without opening the document, or starting the other application. e.g. if using Word I want to read Excel workbook properties without getting an excel object. Similarly with Excel I want to get properties of Word and PPT docs without getting those objects. I note that MS have a DLL for use with .NET and Office 2003, but will this work with Office 97? Alternatively is there another approach?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Accessing document properties (VBA for Office

    Do a search for DSOFile.exe, which I have read about but never actually used. I think it works at least with Office 2000, maybe even earlier versions.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Accessing document properties (VBA for Office 97)

    I think it's worth a try to download the DLL (see Dsofile.dll lets you edit Office document properties without Office) and see if it works in Office 97 VBA. Although the MSKB article mentions only VB.net, it works with VB6 and with VBA in Office 2000 and up. You can view the code in FileProp.frm in any text editor to get an idea of how to use the DLL.

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Location
    U.S. - East Coast
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing document properties (VBA for Office 97)

    I have used this component with Office 97...works beautifully.

  5. #5
    Star Lounger
    Join Date
    Oct 2002
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing document properties (VBA for Office

    THANKS all for the feedback..

    I have now downloaded DSOFILE.DLL and associated package from the microsoft web site...it does work well with Office 97. It's a shame that Microsoft's documentation undersells this product.

    With the DSOFILE tool I can now prepare a catalog of 600+ documents in 40 seconds instead of 40 minutes.

Posting Permissions

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