how can i get the size of folders that exists in a folde

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

George,

In VBA, go to the Tools menu and choose References. There, check the box
next to "Microsoft Scripting Runtime" and use code like the following:

Dim FSO As New Scripting.FileSystemObject
Dim F As Scripting.Folder
Set F = FSO.GetFolder("C:\Temp")
Debug.Print F.Size


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GEORGEBEKOS" wrote in message
...

how can i get the size of folders that exists in a folder


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/