Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Folder Structure and Files from WIndows Explorer to Excel
You can use a recursive funtion using the Dir command or you can create an
instance of the FileSystemObject in the Scripting Runtime and use the folders object. For approaches using DIR Put all this on one line an paste it into your browser: http://groups.google.com/groups?as_q...ng&lr= &hl=en for the filesytem object: http://groups.google.com/groups?as_q...ng&lr= &hl=en Regards, Tom Ogilvy "Tim Beckman" wrote in message ... I'm looking for a way to specify a folder within Windows Explorer and have that folder, subfolders, and files displayed in an Excel sheet row-by-row. This will allow for expansion and contraction of folders and modifications of cells associated w/ folders and files. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Open Excel 2007 Files From Windows Explorer | Excel Discussion (Misc queries) | |||
I could not opened Excel 2002 files from Windows Explorer | Excel Discussion (Misc queries) | |||
Zipping my Excel Files and maintain the folder structure | Excel Discussion (Misc queries) | |||
Excel files won't open from Windows Explorer | Excel Discussion (Misc queries) | |||
Opening DBF files with Excel 2003 via Windows Explorer ? | Setting up and Configuration of Excel |