We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Formula with link to external workbook

Thread ID:

Created:

Updated:

Platform:

Replies:

71276 Jan 24,2008 04:47 AM Jan 28,2008 06:58 AM Windows Forms 1
loading
Tags: XlsIO
Dmitriy Slobodyanyuk
Asked On January 24, 2008 04:47 AM

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 [Syncfusion]
Replied On January 28, 2008 06:58 AM

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.



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;