WorkbookBase.Path Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the complete path to the application, excluding the final separator and name of the application.
public:
property System::String ^ Path { System::String ^ get(); };
public string Path { get; }
member this.Path : string
Public ReadOnly Property Path As String
Property Value
The complete path to the application, excluding the final separator and name of the application.
Examples
The following code example checks the value of the FileFormat property to determine whether the workbook is a normal workbook. If the workbook is a normal workbook, then the example calls the SaveAs method to resave the workbook as an XML spreadsheet with the name XMLCopy.xlsx
in the path specified by the Path property.
This example is for a document-level customization.
private void WorkbookSaveAs()
{
if (this.FileFormat == Excel.XlFileFormat.xlWorkbookNormal)
{
this.SaveAs(this.Path + @"\XMLCopy.xml",
Excel.XlFileFormat.xlXMLSpreadsheet,
false, false, Excel.XlSaveAsAccessMode.xlNoChange);
}
}
Private Sub WorkbookSaveAs()
If Me.FileFormat = Excel.XlFileFormat.xlWorkbookNormal Then
Me.SaveAs(Me.Path & "\XMLCopy.xml", _
Excel.XlFileFormat.xlXMLSpreadsheet, _
AccessMode:=Excel.XlSaveAsAccessMode.xlNoChange)
End If
End Sub