Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
masterkeys masterkeys is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.tables
Jezebel Jezebel is offline
external usenet poster
 
Posts: 1,384
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table of authorities and table of contents in same document? Trish Microsoft Word Help 1 November 2nd 05 06:27 PM
Updating a table of contents Frank Drost Microsoft Word Help 1 July 8th 05 05:54 AM
Updating a table of contents Frank Drost Microsoft Word Help 9 June 29th 05 05:41 AM
developing multiple table of contents Chad Microsoft Word Help 1 June 22nd 05 04:40 AM
table of contents in thesis SSL New Users 1 January 9th 05 11:56 PM


All times are GMT +1. The time now is 10:05 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"