We need to collect information about each of the PCs in our department.
I thought it might be possible to get it by sending a spreadsheet to
each user, which will run a macro to collect the info. I am aware of
the "Environ" function in VBA and have used it in the past to get the
system username but I cannot find anything that tells me what other info
I can gather.

The information that we want from each PC is:

Username (So we know who's PC it is - this much I can already do.)
The name of the PC on the system.
The operating system.
The amount of RAM in the PC.
The type of processor including speed.
The size of the hard disk (needs to be total size of all hard drives,
bearing in mind that the drive might be partitioned or there may be more
than one physical hard drive).

To be honest I don't even know if it is possible for Excel and VBA to
get this info. Can anybody help?

All the PCs are running Office 97. Most use Windows NT4 but some use
Windows 2000.

Thanks,

Graham Standring
University of Sunderland
England