Table of Contents - Directory

[masterkeys]

Hi,

This is gonan be a tricky one, not sure if it can be done, but
anything is possible:

I currently download a lot of online quizzes, in Excel format, that
are numbered.

e.g. cgq00004.xls, cgq29103.xls, cgq01233.xls etc.

They are stored in one directory, with a sub directory of completed
ones.

I would like to build a table of contents, that has the follwing
headers:

Quiz ID (File Name - cgq and .xls) (hyperlinked so I can click on it to
load quiz)

And here's the tricky part:

Title of Quiz - This is either in cell E2 or E3 of the worksheet called
Quiz inside each file!!!!

and last but not least Completed - i.e. if it's in the completed
subfolder, it's done.

Preferabaly I would like it sorted by ID number.

Many Thanks in advance,

either post here, or send me an e-mail to
officefrustration<full_stop>com<at sign>mr8ball
<full_stop>co<full_stop>uk

 

[Jezebel]

Not obvious what your question is. Yes it can be done: iterate the files in
the target folders, get the filenames, open each spreadsheet and read cells
E2 and E3, decide which contains the title, close the spreadsheet, insert
the details into a table in your document. Leave the sorting till last: you
can simply sort the completed table once you have all the data.

Simple if you can write VBA, tricky if you can't.