Image Mso Gallery Menu

Image Mso Gallery Menu.

Publié dans Informatique, Office | Tagué , | 1 commentaire

Excel VLOOKUP – The Massive Guide with Examples

Publié dans Excel, Informatique | Tagué | Laisser un commentaire

Excel Version History

The table below lists the various versions of Excel for Windows that you may encounter.

Version Released Comments
1 1985 Version 1, for the Macintosh was released.
2 1987 The first Windows version was labeled « 2 » to correspond to the Mac version. This included a run-time version of Windows.
3 1990 Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.
4 1992 The first « popular » version. Included lots of usability features.
5 1993 A major upgrade. Included multi-sheet workbooks and support for VBA.
7* 1995 Known as Excel 95. The first major 32-bit version of Excel**. Feature-wise, it’s very similar to Excel 5.
8 1997 Known as Excel 97. A new interface for VBA developers, UserForms, data validation, and lots more.
9 1999 Known as Excel 2000. Can use HTML as a native file format, « self-repair » capability, enhanced clipboard, pivot charts, modeless user forms.
10 2001 Known as Excel 2002, this is part of Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes.This version features product activation technology (i.e., copy protection). Please consider the ramifications of this before deciding whether to upgrade.

Read John Walkenbach’s Excel 2002 Review at PC World.

11 2003 It’s called Microsoft Office Excel 2003.The new features in this version are: (a) improved support for XML, (b) a new « list range » feature, (c) Smart Tag enhancements, and (d) corrected statistical functions. Most users will not find the upgrade worthwhile.
12 2007 Finally, some major changes in Excel. For some, the changes may actually be too major.
14 *** 2010 New features include sparkline graphics, pivot table slicers, an updated Solver, and a 64-bit version..
15 2013 New features include a single-document interface, charting enhancements, and recommended charts and pivot tables.

* There is no Excel 6. Beginning with Excel 7, the version numbering was changed so all of the Microsoft Office applications would have the same version number.

** There was also 32-bit version of Excel 5, but it was not widely distributed.

*** There is no Version 13 of Microsoft Office

Publié le par Louis Dubois | Laisser un commentaire

Environment Variables in Windows Vista, Windows 7, and Windows 8

http://windows7tips.com/environment-variables-windows-vista-7.html

Variable Typical value (may vary)
%ALLUSERSPROFILE% C:\ProgramData
%APPDATA% C:\Users\(username}\AppData\Roaming
%CommonProgramFiles% C:\Program Files\Common Files
%COMPUTERNAME% {computername}
%COMSPEC% C:\Windows\System32\cmd.exe
%HOMEDRIVE% C: or sometimes D:
%HOMEPATH% \Users\{username}
%LOCALAPPDATA% C:\Users\{username}\AppData\Local
%PATH% Varies. Includes
C:\Windows\System32\;C:\Windows\
%PATHEXT% .COM; .EXE; .BAT; .CMD; .VBS; .VBE;
.JS ; .WSF; .WSH; .MSC
%ProgramData% C:\ProgramData
%PROGRAMFILES% Directory containing program files, usually C:\Program Files
%ProgramFiles(x86)% In 64-bit systems, directory containing
32-bit programs. Usually C:\Program
Files (x86)
%PROMPT% Code for current command prompt
format. Code is usually $P$G
%Public% C:\Users\Public
%SYSTEMDRIVE% The drive containing the Windows root
directory, usually C:
%SYSTEMROOT% The Windows root directory, usually
C:\Windows
%TEMP% and %TMP% C:\Users\{Username}
\AppData\Local\Temp
%USERNAME% {username}
%USERPROFILE% C:\Users\{username}
%WINDIR% Usually C:\Windows
Note the changes from Windows XP for the locations of many of the personal files and settings. For example, the « Documents and Settings » folder is gone and there is now a « Users » folder. There are also four new environment variables listed in Table I. These are:

%CommonProgramFiles%
%LocalAppdata%
%ProgramData%
%Public%
The common dynamic variables are similar to those given for XP.

Changes in environment variables between Vista and Windows 7 or 8

There are few changes in the common variables in going from Windows Vista to Windows 7 or Windows 8. As far as I can tell, there is only one worth mentioning. Windows 7 and 8 come with the newer Microsoft command line shell called Powershell. There is an environment variable %PSModulePath% that gives the path to the files for the command line shell. This is usually C:\windows\system32\WindowsPowerShell\v1.0\Modules\

List environment variables in Windows 7 or 8 using PowerShell

In the classical command line, environment variables can be listed with the « set » command. Beginning with Windows7, Microsoft began including the newer command shell called « PowerShell ». The command for listing environment variables in this newer shell is Get-ChildItem Env:

Publié dans Informatique, Windows | Laisser un commentaire

Excel Project Protection Fr.

%,{F11},%,O,E,+,{TAB},{RIGHT},{TAB},{SPACE},{TAB},1,2,3,{TAB},1,2,3,{ENTER},%,F,F,

Publié dans Code, Excel | Tagué | Laisser un commentaire

Excel UnProtect Project Fr

%,{F11},%,O,E,1,2,3,{TAB},1,2,3,{ENTER},{ENTER},%,F,F,

Publié dans Code, Excel | Tagué | Laisser un commentaire

MVVM Tutorial From Start to Finish

MVVM Tutorial From Start to Finish

Publié dans CSharp | Tagué , | Laisser un commentaire

Environment Variables

Environment Variables

Source: Microsoft
Variable Type Description
%ALLUSERSPROFILE% Local Returns the location of the All Users Profile.
%APPDATA% Local Returns the location where applications store data by default.
%CD% Local Returns the current directory string.
%CMDCMDLINE% Local Returns the exact command line used to start the current Cmd.exe.
%CMDEXTVERSION% System Returns the version number of the current Command Processor Extensions.
%COMPUTERNAME% System Returns the name of the computer.
%COMSPEC% System Returns the exact path to the command shell executable.
%DATE% System Returns the current date. Uses the same format as the date /tcommand. Generated by Cmd.exe.
%ERRORLEVEL% System Returns the error code of the most recently used command. A non zero value usually indicates an error.
%HOMEDRIVE% System Returns which local workstation drive letter is connected to the user’s home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%HOMEPATH% System Returns the full path of the user’s home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%HOMESHARE% System Returns the network path to the user’s shared home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%LOGONSEVER% Local Returns the name of the domain controller that validated the current logon session.
%NUMBER_OF_PROCESSORS% System Specifies the number of processors installed on the computer.
%OS% System Returns the operating system name. Windows 2000 displays the operating system as Windows_NT.
%PATH% System Specifies the search path for executable files.
%PATHEXT% System Returns a list of the file extensions that the operating system considers to be executable.
%PROCESSOR_ARCHITECTURE% System Returns the chip architecture of the processor. Values: x86, IA64.
%PROCESSOR_IDENTFIER% System Returns a description of the processor.
%PROCESSOR_LEVEL% System Returns the model number of the processor installed on the computer.
%PROCESSOR_REVISION% System Returns the revision number of the processor.
%PROMPT% Local Returns the command prompt settings for the current interpreter. Generated by Cmd.exe.
%RANDOM% System Returns a random decimal number between 0 and 32767. Generated by Cmd.exe.
%SYSTEMDRIVE% System Returns the drive containing the Windows XP root directory (that is, the system root).
%SYSTEMROOT% System Returns the location of the Windows XP root directory.
%TEMP% and %TMP% System and User Returns the default temporary directories that are used by applications available to users who are currently logged on. Some applications require TEMP and others require TMP.
%TIME% System Returns the current time. Uses the same format as the time /tcommand. Generated by Cmd.exe.
%USERDOMAIN% Local Returns the name of the domain that contains the user’s account.
%USERNAME% Local Returns the name of the user who is currently logged on.
%USERPROFILE% Local Returns the location of the profile for the current user.
%WINDIR% System Returns the location of the operating system directory.
http://libertyboy.free.fr/computing/reference/envariables/
Publié dans Informatique | Tagué | Laisser un commentaire

Excel specifications and limits

http://office.microsoft.com/en-001/excel-help/excel-specifications-and-limits-HP010342495.aspx

Publié dans Excel | Tagué , | Laisser un commentaire

Send Keys

Send / SendRaw / SendInput / SendPlay / SendEvent: Send Keys & Clicks
http://www.autohotkey.com/docs/commands/Send.htm

Publié dans Informatique | Laisser un commentaire