Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skipping Folders | Excel Discussion (Misc queries) | |||
Changing Folders! | Excel Worksheet Functions | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
Keep different views for different folders, not the same for all? | Excel Discussion (Misc queries) | |||
Linking to folders | Excel Discussion (Misc queries) |