+ Reply to Thread
Results 1 to 2 of 2

Accessing Document Properties needs long

  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    Berlin
    MS-Off Ver
    2010
    Posts
    5

    Accessing Document Properties needs long

    Hello.

    I wrote a Excel Macro which writes Names of Files from a SharePoint Library in an Excel Sheet.
    Also some of the Document Properties are written in the sheet, but reading them needs quite a long time, so the macro is working for 15 minutes or so if the library consists of 200 files.
    The code where i read the properties is as follows:

    Please Login or Register  to view this content.
    I figured out that the line "Set objFile = GetObject(strFilename)" is the one who needs this long time to execute.
    Is there a possibility to get this running faster?
    Thanks for any suggestions.

  2. #2
    Registered User
    Join Date
    05-20-2016
    Location
    Berlin
    MS-Off Ver
    2010
    Posts
    5

    Re: Accessing Document Properties needs long

    I figured out, that i can, for example, access the DateLastModified quite easily without opening the file.
    But it seems, this is not working with the Document Properties. Is there another way to get the properties instead of making an new object of the file with GetObject?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Accessing properties of Grouped objects which are inside other groups
    By jgross in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 12:06 PM
  2. [SOLVED] Accessing Properties of a pivot table
    By tlafferty in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-30-2012, 04:27 PM
  3. Accessing a grouped ActiveX control's properties using VBA
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2010, 05:02 AM
  4. Accessing the properties of a shape
    By cweedon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2009, 04:27 PM
  5. Accessing File Properties Question
    By maynard1000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2007, 11:49 PM
  6. [SOLVED] Accessing a Forms Properties
    By Chaplain Doug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2006, 11:10 AM
  7. Accessing file properties
    By Blitzer99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2005, 08:05 PM
  8. [SOLVED] Accessing custom document properties in Word?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2005, 11:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1