-
Articles récents
Commentaires récents
Louis Dubois dans Image Mso Gallery Menu Louis Dubois dans Data Type Conversion (Database… Archives
Catégories
Méta
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
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,
Excel UnProtect Project Fr
%,{F11},%,O,E,1,2,3,{TAB},1,2,3,{ENTER},{ENTER},%,F,F,
Environment Variables
Environment Variables
Source: Microsoft
|
http://libertyboy.free.fr/computing/reference/envariables/
Send Keys
Send / SendRaw / SendInput / SendPlay / SendEvent: Send Keys & Clicks
http://www.autohotkey.com/docs/commands/Send.htm
Publié dans Informatique
Laisser un commentaire