Excel Inventory Sheet - Populate free drive space

[rob4465]

I am in the process of creating an Excel inventory spreadsheet for PCs and laptops within my company. What would be useful is if I could populate each machine with its available drive space (C: Drive). I believe this might be possible using VBA and the FileSystemObject statement.

Does anyone have any idea how this might be achieved?

Assuming all the machines are turned on and live, my spreadsheet will have a PC/Laptop name on each row and a corresponding cell for the drive space.

Machine Drive Space (C)

PC1
PC2
PC3
PC4
PC5


Thanks for any assistance.

[TMS]

Google: excel vba get remote disk capacity … to get some ideas.

This looks particularly useful:

Exposing System Secrets with VBA and WMI API
https://sites.google.com/site/beyond...thvbaandwmiapi