+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Bulk discover whether a document references a data source in another file share in Technical; An attempt to bulk convert some documents to full Office 2007 format (working around compatability mode wierdness) reveals we have ...
  1. #1


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,715
    Thank Post
    288
    Thanked 789 Times in 616 Posts
    Rep Power
    226

    Bulk discover whether a document references a data source in another file share

    An attempt to bulk convert some documents to full Office 2007 format (working around compatability mode wierdness) reveals we have certain people who will create a document on a shared directory that references a data source in their home directory.

    I have a sneaking suspicion the rot has set in and this affects hundreds of files, but no way to check beyond opening them manually.

    Is there a way of checking if a file at \\server\share\path\file.doc references: a) an external data source (.xls, .mdb) b) whether (with my current permissions) I can access that data source?

    edit: Assuming I know the data path the culprits usually use (homedriveletter:\foldername) I can run strings on the documents on the shared area and grep for the paths, but is there a better (more reliable) way?
    Last edited by pete; 16th November 2009 at 02:00 PM.

  2. #2
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,007
    Thank Post
    124
    Thanked 286 Times in 263 Posts
    Rep Power
    109
    References are held as a collection:

    Code:
    VBE.ActiveVBProject.References
    never played with this but it was a suggestion for a problem I had. I find the best place for asking questions is VBA Express Portal . There is a few friendly MVPs on there and I always seem to get a good thorough answer.



SHARE:
+ Post New Thread

Similar Threads

  1. Create bulk ad groups from a csv file
    By ful56_uk in forum Windows
    Replies: 2
    Last Post: 20th July 2009, 06:06 PM
  2. 2003 Share Offline Settings Bulk
    By Embazzy in forum Windows
    Replies: 2
    Last Post: 16th January 2009, 04:12 PM
  3. Replies: 5
    Last Post: 10th December 2008, 01:59 PM
  4. Bulk Modify Share Permissions
    By mitchell1981 in forum Windows
    Replies: 4
    Last Post: 11th July 2007, 01:33 PM
  5. Replies: 1
    Last Post: 24th November 2005, 11:57 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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