ProtectedViewWindow.SourcePath property (Excel)

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



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 property to return the source file name without the path.


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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.