multiple hyper link and

Hi,

there are lots of VBA tools that read the files in a folder and return a list in Excel. One that might serve as a starting point for you is here:

http://www.excelforum.com/excel-prog...in-folder.html

The macro described there will list the file names and some other file attributes into an excel spreadsheet. You can then add a column where you create the hyperlink with the function

=HYPERLINK(C2,B2)

where C2 has the full path name and B2 has the "friendly name" for the file.

The macro gives you columns for
- file name
- full path
- size
- date created
- date modified
- owner

You can add more columns to the table manually, or you could modify the macro.

For Example, the following function code will return the Title from the file properties:

Please Login or Register  to view this content.

To use the function in the macro you must add a line in the Sub of the code I linked to, something like:

Please Login or Register  to view this content.

Look at the file properties for your PDF files to see what file attributes you want excel to read. Play around with the macro to see which numbers to adjust to read these properties. For example, the Title property required that I change a 9 to a 10 in the line

Please Login or Register  to view this content.

I found this out with trial and error, but I'm sure all other file properties can be read with this method.

You may have other ways of classifying your PDFs, but that's probably a manual data entry process.

HTH