Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Making an excel file with all excel files on my PC

0

Good evening,

I am a new subscriber and I have a question because I can't find anywhere on Google the correct solution. Maybe you can help me.

I use on my laptop Excel 2010 and I would like to generate an Excel-file in which there is an overview of all the excel-files on my computer. It would also be very nice if every file is linked to the correct place on my computer so that by clicking on it the exce-file opens.

Is this possible?

Thanks in advance for your reaction.

Best regards,

Eric

Answer
Discuss

Answers

0

You can't find it because nobody wants it. That begs the question why you do. And that raises the question if you do really do. Let's consider the problem.

Would you really want a list of all Excel files on your computer?
That would include files you download and forget, some program files, and any amount of rubbish files that accumuate on any computer over time.

A more normal requirement would be to list all files in one directory. If the files are in several directories you would probably want to list them in categorised lists, one list per column or per worksheet.

The first problem you encounter when you create such a limited list is that Windows Explorer already does it for you and its hard to do it better. If you have all the Excel files that interest you in one directory, perhaps with sub-directories, you can click on any one and open it. No need for an Excel sheet.

Perhaps you store all files that you create in the Documents folder. When you open that folder in Windows Explorer you see the list of all files of all types - quite messy, and your idea would sort the mess.

But Excel already thought of that, too. Open Excel, Click File / Open, browse to the folder with your files and, voila, there they are: Excel files only, in alphabetical order or sorted by date, large icons, small icons or "List". Click and open. It's faster than your idea and more versatile.

For example, you can further limit the selection of workbooks by modifying the filter (above the buttons in the File Open dialog) to show only xlsx or xlsm workbooks or perhaps xls (the pre-2007 format).

What is that your Excel sheet with listed workbooks should be able to do that Windows and Excel don't already do to your satisfaction?

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login