Skip to content

Latest commit

 

History

History
46 lines (26 loc) · 1.14 KB

Excel.ProtectedViewWindow.SourcePath.md

File metadata and controls

46 lines (26 loc) · 1.14 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ProtectedViewWindow.SourcePath property (Excel)
vbaxl10.chm914082
vbaxl10.chm914082
Excel.ProtectedViewWindow.SourcePath
add00cce-b8e9-5a11-b1cb-27ac63798491
05/09/2019
medium

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

Example

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

[!includeSupport and feedback]