Bewerken

Delen via

ProtectedViewWindow.SourcePath property (Excel)

  • Artikel

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

Example

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.