Export (0) Print
Expand All
P
Expand Minimize

Path Property [Excel 2003 VBA Language Reference]

Office 2003

Sets or returns the complete path to where Microsoft Excel will store the AutoRecover temporary files. Read/write String.

expression.Path

expression Required. An expression that returns an AutoRecover object.

Returns the complete path to the application, excluding the final separator and name of the application. Read-only String.

expression.Path

expression Required. An expression that returns one of the above objects.

Example

This example sets the path of the AutoRecover file to drive C.

Sub SetPath()

    Application.AutoRecover.Path = "C:\"

End Sub
				

This example displays the complete path to Microsoft Excel.

Sub TotalPath()

    MsgBox "The path is " & Application.Path

End Sub
				




Show:
© 2014 Microsoft