Want to automate the msofiledialogfolderpicker

[jacc14]

Hi I love this code but there are times when i don't want the user to actually pick a folder. At the moment when running the code you are prompted to "select a folder to list files from" I want to hard code in the folder name so at the click of a button it will show all the current files in C drive. Can anyone help please. I have tried different codes but this is the most user friendly as it shows the files names very quickly. I hope this makes sense

Regards
Christine

Please Login or Register  to view this content.

[kev_]

is this what you want?

Please Login or Register  to view this content.

Welcome to the forum
Please use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).
[ code ]
your code here ...
and here ...
and here
[ /code ]
Please amend your first post
thanks

[jacc14]

This is spot on . Thank you so much for your help

Kindest regards
Christine

[kev_]

Thanks for rep
Please click ThreadTools at top of thread and mark thread SOLVED
Thanks