Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count subfolders
Hi,
The properties of a windows folder gives you file size on disk, file count, and folder count. I need a vba to extract that info. Any ideas??? peter (nested folders and files included) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count subfolders
Sub GetFolderInfo() strFolder = "C:\temp" Set fso = CreateObject _ ("Scripting.FileSystemObject") Set folder = _ fso.GetFolder(strFolder) FolderSize = folder.Size Files = folder.Files.Count Subfolders = folder.Subfolders.Count Size = folder.Size End Sub -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149288 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add subfolders and name - Possible? | Excel Programming | |||
Auto look through subfolders | Charts and Charting in Excel | |||
please help me with folder and subfolders | Excel Programming | |||
copy subfolders, replace text in files and save files in copied subfolders | Excel Programming | |||
Get list of subfolders | Excel Programming |