File Indexing

[Shabbo]

Dear Sir,

I have over 100 files and more than 10 folders in my PC.

Like Bank statement in PDF.

Accounting reports in Excel.

Bank Letters and Word.

I wanted to make a list of all documents in excel and give hyperlinks so once I click any document it should open.

Please help me.

 

[BobBridges]

How much do you already know about writing programs in VBA, Shabbo? Do you need a little help with some of the concepts? Or do you know nothing, and really just want someone to write the program for you?

 

[Marc L]

and more than 10 folders in my PC

I wanted to make a list of all documents

Hello, as a reminder any Excel forum is not a mind readers forum so you must well elaborate your need in order there is nothing to guess ‼​

​

I wanted to make a list of all documents in excel and give hyperlinks so once I click any document it should open.

So first you must create manually on a new test workbook a hyperlink for each type of so called 'documents'​

in order to see which types work on your side then revert here the list of only those working …​

​