VB code to list file names from folder

[rizmomin]

Hello:

I have lots of .xls and .pdf files in c:\Files\

I need VB Code to list Names of the .xls file starting at cell A1 and .pdf file in cell B1 of excel file "Sheet1"

Please let me know if you have any questions.
Thanks.

Riz

[rizmomin]

Hello:

I got the solution.
Thanks

Riz

[daboho]

Perhab like this

Please Login or Register  to view this content.

[jolivanes]

@ rizmomin.
Would you be so kind and share your code that solved your problem here for other people that could be looking for a same problem solution.
Thank you very much