Retrieving actual Forumla string

[Grant]

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.

 

[Cindy M.]

Hi Grant,

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.

Is this related to, or separate from, your other question?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail