I need to gather information from my users regarding the operating system and version of office in use. I would like this to be in a set format, and detailed...without the user having to run a macro (manually).

My thoughts were to put together a workbook with an 'Open' event that looks at the registry to get this information, which is then presented in the workbook via a UDF e.g.

=SystemVersion() {Windows 7 SP1, Windows XP SP2, Windows 2000, Windows Vista SP2}

=OfficeVersion() {Office 2000, Office 2003, Office 2007 12.0, Office 2010}

Any help would be appreciated. I tried using =INFO but would like more information than 'pcdos' and '12.0'.

Using this method the user could then simply copy the cells and drop them to me in an email...