Thursday 16 February 2012

Environ VBA Command in Microsoft Excel 2007

Title:
Environ VBA Command in Microsoft Excel 2007


Video:


Description:This video shows how to use the Environ command to get the username (Window NT Name). There will also be an if statement, count if and else statement used. Items Covered: Environ VBA Command If statements, else if, countif, user NT, user log in, log in name, authorize, authorization, Environ Command Uses: ALLUSERSPROFILE,APPDATA,AVENGINE,CLIENTNAME,COMMONPROGRAMFILES,COMPUTERNAME,COMSPEC,FP_NO_HOST_CHECK,HOMEDRIVE,HOMEPATH,LIB,LOGONSERVER,NUMBER_OF_PROCESSORS,OS,PATH,PATHEXT,PROCESSOR_ARCHITECTURE,PROCESSOR_IDENTIFIER,PROCESSOR_LEVEL,PROCESSOR_REVISION,PROGRAMFILES,SESSIONNAME,SYSTEMDRIVE,SYSTEMROOT,TEMP,TMP,USERDOMAIN,USERNAME,USERPROFILE

Published:
16/Feb/2012

No comments:

Post a Comment