worksheet with content of a directory

J

Jack Sons

Stan,

Thanks for your help. I got the code, but don't know how to work with it (as
it is now it does nothing). I do not understand the "example".
If I have to fill in somewhere the complete path (often very long) of the
directory that I want to list, it could be very cumbersome. Is an easier way
possible? The code in my original posting works on any opened directory that
appears in my Explorer, no need to type in a long path. Is that also
possible with Leith's code when (a bit) augmented?

I also do not understand Randy's reply; "had to change the objFolderItem
from "8" to "9"". Why? What does it mean?

I look forward to your assistance.

Jack.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to count rows with content 1
worksheet with content of a directory 4
restrict a user to a directory 1
Restrict User to a directory 1
restrict user to a directory structure? 3
looking for help with syntax error 5
Need help modifying code 0
Adapt this Directory Listing working code to insert a file namepattern prompt. 1

Top