When I insert an OLE object (Insert Object Create From File), the
caption below the actual icon is whatever filename I specified in the
Create From File textbox. Is there any way to get this source filename
by code? I remember seeing .SourceName somewhere, but it failed for
whatever reason. Does anyone have a specific example?

From the Visual Basic Help file (Excel 2000)

SourceName Property


OLEObject, OLEObjects objects: Return or set the specified object's link
source name. Read/write String.

CubeField, PivotField, PivotItem objects: Return the specified object's
name, as it appears in the original source data for the specified PivotTable
report. This might be different from the current item name if the user
renamed the item after creating the PivotTable report. Read-only String.

The following table shows example values of the SourceName property and
related properties, given an OLAP data source with the unique name
"[Europe].[France].[Paris]" and a non-OLAP data source with the item name
"Paris".

Property Value (OLAP data source) Value (non-OLAP data source)
Caption Paris Paris
Name [Europe].[France].[Paris] (read-only) Paris
SourceName [Europe].[France].[Paris] (read-only) (same as SQL property
value, read-only)
Value [Europe].[France].[Paris] (read-only) Paris


When specifying an index into the PivotItems collection, you can use the
syntax shown in the following table.

Syntax (OLAP data source) Syntax (non-OLAP data source)
expression.PivotItems("[Europe].[France].[Paris]")
expression.PivotItems("Paris")


When using the Item property to reference a specific member of a collection,
you can use the text index names shown in the following table.

Name (OLAP data source) Name (non-OLAP data source)
[Europe].[France].[Paris] Paris



--
steveB

Remove "AYN" from email to respond
wrote in message
ups.com...
When I insert an OLE object (Insert Object Create From File), the
caption below the actual icon is whatever filename I specified in the
Create From File textbox. Is there any way to get this source filename
by code? I remember seeing .SourceName somewhere, but it failed for
whatever reason. Does anyone have a specific example?