Download User`s Manual and Reference Guide

102
ExcelLink
In[2]:=
$ExcelDialogs
Out[2]=
{Range, Open, Save, Files, Folder}
In[3]:=
ExcelDialog["Folder","Select a folder"]
Out[3]=
C:\Documents and Settings\Anton\My Documents
$ExcelDirectories
$ExcelDirectories
gives a list of supported special directories that can be used with the ExcelDirectory function.
Details
◼ "Installation" is the directory where Excel is installed.
◼ "Home" is the default file location in Excel. This is specified in Excel under Tools ▶ Options... ▶ General.
◼ "User" is the directory where Excel user settings are stored.
◼ "Link" is the directory where Mathematica Link for Excel is installed.
Examples
In[1]:=
<<ExcelLink`
In[2]:=
$ExcelDirectories
Out[2]=
{Installation, Home, User, Link}
In[3]:=
ExcelDirectory /∕@ $ExcelDirectories
Out[3]=
{C:\Program Files\Microsoft Office\Office10, C:\Documents and Settings\Anton\My Documents,
C:\Documents and Settings\Anton\Application Data\Microsoft,
C:\Documents and Settings\Anton\Application Data\Mathematica\Applications\ExcelLink}
$ExcelGraphic
$ExcelGraphic
is an internal counter used to display graphics in Excel .
Examples
In[1]:=
<<ExcelLink`
In[2]:=
$ExcelGraphic
Out[2]=
0