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. |
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. |
All times are GMT +1. The time now is 06:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com