Hi,

Been a long time reader of the forum and usually can find bits and pieces of macros to edit and use; so firstly I'd like to say thanks!

My current project is quite a different matter, and I must admit that I have limited understanding of macro writing so here goes...

I'm trying to automate a document version control spreadsheet, so that when I run the macro, everything in the spreadsheet updates automatically.

The idea is to have the following word documents in the following filing system:

c:\document path\study1\reports\site1\audit date1\draft\v1
c:\document path\study1\reports\site1\audit date1\draft\v1-1
c:\document path\study1\reports\site1\audit date1\reviewed\v2
c:\document path\study1\reports\site1\audit date2\draft\v1
c:\document path\study1\reports\site1\audit date2\draft\v1-1
c:\document path\study1\reports\site1\audit date2\reviewed\v2
c:\document path\study1\reports\site2\audit date1\draft\v1
c:\document path\study1\reports\site2\audit date1\draft\v1-1
c:\document path\study1\reports\site2\audit date1\draft\v1-2
c:\document path\study1\reports\site2\audit date1\reviewed\v2
c:\document path\study2\reports\site1\audit date1\draft\v1
c:\document path\study2\reports\site1\audit date1\reviewed\v1
etc...

I'd need the different studies on different worksheets too!
the columns I'd need are:

Study 1 worksheet

Site
author (from the word doc properties)
audit date
draft date (from within the word doc itself (as a field))
reviewed date (from within the word doc itself (as a field))
Draft version Number1 (from within the word doc itself (as a field))
Draft version Number2 (from within the word doc itself (as a field))
Draft version Number3 (from within the word doc itself (as a field))
Reviewed version number (from within the word doc itself (as a field))

Study 2 worksheet

Site
author (from the word doc properties)
audit date
draft date (from within the word doc itself (as a field))
reviewed date (from within the word doc itself (as a field))
Draft version Number1 (from within the word doc itself (as a field))
Draft version Number2 (from within the word doc itself (as a field))
Draft version Number3 (from within the word doc itself (as a field))
Reviewed version number (from within the word doc itself (as a field))

It would be good if all of the data above occurred on one row for each date, rather than each site, because the audit date is the key field.
It would also be nice if the version numbers also had hyperlinks to the appropriate file.

I've been searching for a solution for this for ages now and not found anything suitable, except for maybe this one by Leith Ross -> http://www.excelforum.com/excel-prog...directory.html

Is this even possible? It would be amazing if it could be done!

Thanks,
Drcocktail