automatically generate links from a directory and its sub-directories
Hi all,
I want to create a macro that would provide me a listing of a directory and its sub-directories and create hyperlinks to all the .pdf files in these dir's. I would like to capture the directory names too .Also I would like to updates these links everytime the spreadsheet is opened. My directory structure is : c:\Pending Cases Year_2007 a b |
All times are GMT +1. The time now is 10:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com