LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
grewpp
 
Posts: n/a
Default Creating Links to files in a shared directory


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code error in creating text files Greshter Excel Discussion (Misc queries) 3 January 15th 06 09:34 PM
opening excel files with links to other data sources Saul Excel Discussion (Misc queries) 1 May 23rd 05 12:27 AM
Maintain cell links when renaming directory containing multiple f Excel52 Excel Worksheet Functions 0 April 28th 05 10:54 PM
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 1st 05 11:31 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"