Thanks for the quick responses.
I will download the new xla file and try now.
Much appreciated.

cheers Paul

On Mar 14, 12:35 pm, "Chip Pearson" wrote:
I put a new version of the XLA file on the site atwww.cpearson.com/excel/foldertree.htm. It gives you the option to display
folder and/or file sizes in bytes, KB, or MB.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLCwww.cpearson.com
(email on the web site)

"Chip Pearson" wrote in message

...



Paul,

In the module "modFolderTree", search for the lines (about line numbers
335 - 340)

If FullPaths = True Then
Dest.Value = FolderObj.Path
Else
Dest.Value = FolderObj.Name
End If

and replace them with the following:

If FullPaths = True Then
Dest.Value = FolderObj.Path & _
" (" & Format(FolderObj.Size / 1048576, "###,0 MB") & ")"
Else
Dest.Value = FolderObj.Name & _
" (" & Format(FolderObj.Size / 1048576, "###,0 MB") & ")"
End If

I might make including the folder and/or file size an additional option on
the form. Its a good idea.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"Paul" wrote in message
oups.com...
Hi all,

I have used Chip Pearsons Dir Tree, which is great, however I need
some code that tells me how much MB is used in a directory level that
I choose.
Can any one help me with this please.

I'm not good at writing VB code, but can follow it a bit.

TIA Paul- Hide quoted text -

- Show quoted text -