Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count rows with content
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count rows with content
You had another post at your other thread.
Jack Sons wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count rows with content in some columns | Excel Discussion (Misc queries) | |||
Count Columns, Return Content | Excel Worksheet Functions | |||
Filling only cells for rows with content | Excel Worksheet Functions | |||
Delete rows by content | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |