Formula with link to external workbook

[Dmitriy Slobodyanyuk]

Hi all!

I need programmaticlly manipulate by references to external workbooks in formulas.
For example, how could i change formula
='D:\VRP\[A_77_05.xls]SPs'!$D7
to
='D:\VRP\[Fa_77_06.xls]SPs'!$D7
?

I get text ='#REF'!$D7 by using IRange.Formula property.

[Vishnu Kumar]

Hi Dmitriy,

programmaticlly manipulate by references to external workbooks in formulas:

I regret to let you know that currently we do not provide support for this feature in our code library. we have already logged a request in our feature management system. We will get back to you once this feature is implemented.

Please let me know if you have any other concerns.

Regards,
Vishnu.