VB.Net - retrieve actual formula string
 

Hi,

I am using VB.Net (Interop) to reference an Excel Workbook, and want to
retrieve the actual formula string rathar than the result of the formula.

So if the formula in Excel was =SUM(B5:B8) then the string I would want to
return would be "=SUM(B5:B8)"

I have tried almost every property but still can only seem to get the value.

Any help would be much appreciated.

Thanks in advance,

Grant.

VB.Net - retrieve actual formula string
 

From the imediate Window (from an at-random file I have open)

? Activecell.Formula
=IF(ISBLANK(H7),0,IF(H7<=TODAY(),D7,0)) << Produces in text form

HTH

"Grant" wrote:

Hi,

I am using VB.Net (Interop) to reference an Excel Workbook, and want to
retrieve the actual formula string rathar than the result of the formula.

So if the formula in Excel was =SUM(B5:B8) then the string I would want to
return would be "=SUM(B5:B8)"

I have tried almost every property but still can only seem to get the value.

Any help would be much appreciated.

Thanks in advance,

Grant.