View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Environmental Variables

ENVIRON() gives you the UserName , ComputerName. Will help ??

Msgbox Environ("UserName")
Msgbox Environ("ComputerName")


If this post helps click Yes
---------------
Jacob Skaria


"John G." wrote:

Is there a envstring for the Environ() function that will return a unique
value, such as a serial # of the processor, Windows, Office, etc?

I want to setup some type of security should the XLS and not the XLT be
copied for use on another computer. I have no problem with the copying, it's
just that there will be CC info stored in the existing XLS file and I don't
want that to be distributed.
If I can check for two or three unique serials, I can have the routine clear
the existing data and reset the XLS to it's original delivered status. By
having more than one serial # to check, I can make sure the reset won't
happen should a minor hardware swap take place.

Sometime ago, I worked on a project in FoxPro where the code used a primary
harddrive serial # as a seed for an activation code. Was look for a similar
avenue if it's not too complicated.
Thx, JG