vba that give you folders size
 

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

vba that give you folders size
 

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/