Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Table of Contents - Directory
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 officefrustrationfull_stopcomat signmr8ball full_stopcofull_stopuk -- masterkeys |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Table of Contents - Directory
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. "masterkeys" wrote in message ... 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 officefrustrationfull_stopcomat signmr8ball full_stopcofull_stopuk -- masterkeys |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table of authorities and table of contents in same document? | Microsoft Word Help | |||
Updating a table of contents | Microsoft Word Help | |||
Updating a table of contents | Microsoft Word Help | |||
developing multiple table of contents | Microsoft Word Help | |||
table of contents in thesis | New Users |