NTDOC
Administrator
   
Registered: 2000-07-28
Posts: 11616
Loc: CA
|
Well putting a couple of UDFs together we can search for ALL the products and have them output the ProductName and Key something like this
- Microsoft Office Professional Edition 2003: XY7HB-8K3T4-KWLXC-KCTWW-VKKPM
- Microsoft Office Visio Professional 2003: M58HJ-B4WW3-6X5MR-G8HD3-XSQSY
- Microsoft Windows XP: RJTHT-PPKPY-EE7R6-DRGSB-KJMRT
Using the SearchReg() UDF from Kholm http://www.kixtart.org/ubbthreads/showflat.php?Cat=0&Number=83331
and the updated one from Christian and Golfed by Chris I came up with this.
|