Thank you both for you help, both examples give me the results I require and
help me to understand programming excel/macros better.

"Damon" wrote:

Thank you, that appears to be the instruction I need but can anybody tell me
how I would use it get the properties for a folder and then copy the
infomation I need (Folder size, Number of files & Number of folders) into
seperate cells within excel?

Thank you in advance

"Ardus Petus" wrote:

Yes: use FileSystemObject
I'm not sure about folder size.

HTH
--
AP

"Damon" a écrit dans le message de news:
...
Is it possible to get the properties of a folder/drive from within an
Excel
macro and then populate seperate cells with the folder/drive size, number
of
files & number of folders?