Thread
:
system calls in excel
View Single Post
#
5
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
system calls in excel
I forgot the attachment:
http://cjoint.com/?fspSDS4wrK
--
AP
"Damon" a écrit dans le message de news:
...
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?
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus