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 ...
16th November 2009, 01:54 PM #1
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.
IDG Tech News
16th November 2009, 02:07 PM #2
References are held as a collection:
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.
By ful56_uk in forum Windows
Last Post: 20th July 2009, 06:06 PM
By Embazzy in forum Windows
Last Post: 16th January 2009, 04:12 PM
By box_l in forum Windows
Last Post: 10th December 2008, 01:59 PM
By mitchell1981 in forum Windows
Last Post: 11th July 2007, 01:33 PM
Last Post: 24th November 2005, 11:57 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)