How to create a list of Excel Workbooks

[aburashed]

Hello guys,
I want help to make a list of all Excel Workbooks in specific folder(My Documents). And once clicked, it will open the file immediately. Please reply.

[hectop]

The following code will list/display the files in a directory. You would need to modify the path and the file extension.
Click Yes to open the file; No to move to the next file.

Not sure if this is exactly what you are looking for, but you requirements are a bit light.

Please Login or Register  to view this content.

[aburashed]

dont know how to work with codes. please help me brother.

[hectop]

Open a workbook.
Click Alt+F11 to open VBA editor
Click Insert | Module
Copy the code into the screen on the right (below where it says General)
Save the file. Depending on the version, you may need to save is as a macro enabled workbook (.xlsm)
Go back to the spreadsheet
You can run it by clicking on the Macros icon, select file_list, and then click RUN

[aburashed]

I select file_list and clicked run..nothing happens.

[hectop]

Please post your workbook where you installed the macro. It's hard to say what could be the problem

[aburashed]

Attached is the workbook where i posted your Codes. I am sorry if i did something wrong. Expect from you to correct the issue. Thank you bro.

[reimar_rem]

Hi hectop,

Try using HYPERLINK function.

1st file your workbooks in 1 new folder (example name: "Input").
2nd create new workbook (example name "output") work on summarizing the title of your workbooks.
3rd Open input folder copy the address above paste in cell A1 in ouput workbook.
4th type file extension in cell A2
5th open this attachment sample 4.xlsx

[reimar_rem]

Hectop:

used this formula:

=HYPERLINK(CONCATENATE(A1,"/","tile of your workbook",".",A2),B3)

[hectop]

I tried Book1.xlsm that you posted. It works fine.
Ensure that you modify this line to the appropriate directory

Please Login or Register  to view this content.

You also may have to enable macros. Check Macro Security on the Developer tab.

I'm not sure what you're question is about the hyperlink. If you want to modify the code to create a list of excel files in the
spreadsheet then you can use this code

sample 4.xlsm

[Fotis1991]

Imran310

In this post the Moderator asked you "what was the purpose of that post"? I ask the same here and as i noticed you did the same to three more threads.

So pls stop to do this as there is no sense of doing that and take a look to forum rules. Else you force us to ban you from the forum.