Copy windows folder contents as a link and insert into worksheet

[robbo1172]

Hi

I am learning VBA as I go and whilst I have done a search I couldn't find a solution.

I need to copy a windows folder contents filenames into a worksheet.

Presently I navigate to the folder I need to copy from, do a SELECT ALL, SHIFT and RIGHT CLICK, COPY AS PATH and PASTE VALUES it into the worksheet.

Is this something that VBA could perform or do I need to look for other means.

Any clues or help would be greatly appreciated.

TIA, Anthony

[ImranBhatti]

Check https://stackoverflow.com/questions/...lder-using-vba

[robbo1172]

Thanks for the link. I’ll give it a go tomorrow. Much appreciated.

Anthony

[robbo1172]

I have assembled the following code (I am still in the very early stages of learning VBA) which will retrieve the first file name and output to cell A1, but that is all. If there are 10 file names in the folder, cells A1 to A10 should all have file names in them. Could someone please point me in the right direction.

Thanks

Please Login or Register  to view this content.

Thanks in advance

[ImranBhatti]

try this

Please Login or Register  to view this content.

[ImranBhatti]

This should also work

Please Login or Register  to view this content.

[rorya]

I have assembled the following code ...

Just a typo. This line:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

since you're using Counter to determine the output location. Option Explicit is your friend.

[robbo1172]

Thank you so much for your help, it works perfectly (I did use the second code that you suggested). Rather than blindly accept and use solutions offered by other people, I like to work through how it was done so I can learn as I go, I really appreciate your very clear notes as to what each part of the code does.

Once again, thank you my friend

[ImranBhatti]

Thanks for the feedback and rep+
Glad to have helped.