Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting folder size information into cell???
Hello, I can't seem to figure out how to get folder size information into an excel spreadsheet cell. I have the filer/server location information in one cell and I'd like to use the information within that cell to extract the folder/directory size and populate another cell. I can't seem to figure out how to go about this? Any suggestions and/or solutions (if any) would be greatly appreciated. Please bear in mind, I'm a noob with this excel programming. ;-) Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting folder size information into cell???
strFolder = "C:\temp"
Set fso = CreateObject _ ("Scripting.FileSystemObject") Set folder = _ fso.GetFolder(strFolder) FolderSize = folder.Size Range("A1") = folderSize "Will" wrote: Hello, I can't seem to figure out how to get folder size information into an excel spreadsheet cell. I have the filer/server location information in one cell and I'd like to use the information within that cell to extract the folder/directory size and populate another cell. I can't seem to figure out how to go about this? Any suggestions and/or solutions (if any) would be greatly appreciated. Please bear in mind, I'm a noob with this excel programming. ;-) Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
document information from folder | Excel Discussion (Misc queries) | |||
Font Information for a cell with multiple color and size | Excel Programming | |||
Folder information | Excel Discussion (Misc queries) | |||
Folder Size | Excel Programming | |||
Reading information from all workbooks in a folder... | Excel Programming |