Getting folder size information into cell???

[Will]

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.

 

[Joel]

strFolder = "C:\temp"
Set fso = CreateObject _
("Scripting.FileSystemObject")
Set folder = _
fso.GetFolder(strFolder)
FolderSize = folder.Size
Range("A1") = folderSize