ProtectedViewWindow.SourcePath Property (Excel)

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


expression. SourcePath

expression A variable that represents a 'ProtectedViewWindow' object.

Return value



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.


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

See also

ProtectedViewWindow Object