Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet with content of a directory
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. "stanleydgromjr" schreef in bericht ... Jack Sons, See: Leith Ross 'List files in folder - Excel Help Forum' (http://tinyurl.com/n9ktdl) Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127849 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet with content of a directory | Excel Discussion (Misc queries) | |||
How to display the current directory for existing worksheet? | Excel Discussion (Misc queries) | |||
Membership Directory in Word from Excel Worksheet | Excel Discussion (Misc queries) | |||
default save directory for a templated worksheet | New Users to Excel | |||
Listing Directory Contents in Worksheet | Excel Discussion (Misc queries) |