Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
How do I find out my hard drive size.
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
Hi Denise
In Windows Explorer or My Computer, right click on the Drive letterproperties -- Regards Roger Govier "DENISE" wrote in message ... How do I find out my hard drive size. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
"DENISE" wrote in message
... How do I find out my hard drive size. My Computer or Computer depending on your OS. How is this an EXCEL question? -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
Easy:
Sub servient() sPath = "C:" Set oFs = CreateObject("Scripting.FileSystemObject") Set drv = oFs.GetDrive(oFs.GetDriveName(sPath)) fullsize = drv.TotalSize MsgBox (fullsize) End Sub -- Gary''s Student - gsnu200837 "DENISE" wrote: How do I find out my hard drive size. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
"Gary''s Student" wrote in message
... Easy: Sub servient() sPath = "C:" Set oFs = CreateObject("Scripting.FileSystemObject") Set drv = oFs.GetDrive(oFs.GetDriveName(sPath)) fullsize = drv.TotalSize MsgBox (fullsize) End Sub ROTFLMAO! -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
Its the only answer that makes sense in an Excel context. If the poster was
interested in the physical size rather than the disk capacity, the answer would have been to open the computer and measure the length, width, and height with a tape measure! -- Gary''s Student - gsnu200838 "Gordon" wrote: "Gary''s Student" wrote in message ... Easy: Sub servient() sPath = "C:" Set oFs = CreateObject("Scripting.FileSystemObject") Set drv = oFs.GetDrive(oFs.GetDriveName(sPath)) fullsize = drv.TotalSize MsgBox (fullsize) End Sub ROTFLMAO! -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
But we had insufficient information to properly answer it in that context:
inches or cm was not specified. So, I believe your response is accurate and within context <g "Gary''s Student" wrote: Its the only answer that makes sense in an Excel context. If the poster was interested in the physical size rather than the disk capacity, the answer would have been to open the computer and measure the length, width, and height with a tape measure! -- Gary''s Student - gsnu200838 "Gordon" wrote: "Gary''s Student" wrote in message ... Easy: Sub servient() sPath = "C:" Set oFs = CreateObject("Scripting.FileSystemObject") Set drv = oFs.GetDrive(oFs.GetDriveName(sPath)) fullsize = drv.TotalSize MsgBox (fullsize) End Sub ROTFLMAO! -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HARD DRIVE
May not have specifically been an Excel question - but she had smarts enough
to come to the group that she knew could handle an adhoc question! "Gordon" wrote: "DENISE" wrote in message ... How do I find out my hard drive size. My Computer or Computer depending on your OS. How is this an EXCEL question? -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
When I save a file on the hard-drive, it is fine, I can re-open, | Excel Discussion (Misc queries) | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
how do i find a deleted file on my hard drive | Excel Discussion (Misc queries) | |||
Automatic backup in excel with copy to hard drive and to cd-rw | Excel Discussion (Misc queries) |