ProtectedViewWindow.SourcePath Property (Excel)

Returns the path of the source file that is open in the specified Protected View window. Read-only

Syntax

expression. SourcePath

expression A variable that represents a 'ProtectedViewWindow' object.

Return Value

String

Remarks

The path does not include a trailing character (for example, "C:\MSOffice"). Use the PathSeparator property to add the character that separates folders and drive letters. Use the SourceName of the ProtectedViewWindow object to return the source file name without the path.

Example

MsgBox ActiveProtectedViewWindow.SourcePath &; Application.PathSeparator _ 
 &; ActiveProtectedViewWindow.SourceName 

See also

ProtectedViewWindow Object