-
VBA / Formula approach
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules