hi grewpp

Try this example
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"grewpp" wrote in message
...

I have a large number of files on a shared directory that I need to be
able to easilly obtain a list of and to insert links to. These files
are regularly updated and can have new ones added and deleted.

Ideally I would like to be able to do the following things:

1) Automatically output a list of the excel files within the directory,
including those within subfolders into excel.

2) If 1 is achievable would it then be possible to automatically create
links to the data within these spreadsheets that I need to extract.

I do hope somebody can assist.
Paul


--
grewpp
------------------------------------------------------------------------
grewpp's Profile: http://www.excelforum.com/member.php...o&userid=31005
View this thread: http://www.excelforum.com/showthread...hreadid=508848