TOtal Drive space formula

[matty0511]

I have attached my excel spreadsheet that i need help with. What I am trying to do is create a total of hard drive space used for each hard drive/datastore. For example in my spreadsheet i have the name of my server in one column and then in another column i have the name of the datastore where that server resides on. My wietingdc server has a 45GB hard drive that sits on my DSSSD240 drive. I want to be able to calcualate the amount of used/free space for all of my hard drives.

[mikeTRON]

Did you try google?

https://support.microsoft.com/en-us/kb/153091
http://www.mrexcel.com/forum/excel-q...rive-spac.html
http://www.excelforum.com/excel-prog...remaining.html


this gets free space remaining, but you have to enable Microsoft scripting Runtime library in references.

Sub test()
Dim oFSO As FileSystemObject
Dim strDrive As Drive

Set oFSO = New FileSystemObject
Set strDrive = oFSO.GetDrive("C:\")
MsgBox FormatNumber(strDrive.FreeSpace / 1024, 0)


End Sub