Getting result of formula instead of actual formula
 

I am working on a routine to send information from excel to a users
quickbooks company file. If the user has created a formula to calculate
the value of a cell when the import routine sends it to quickbooks it
sends the formula instead of the result of the formula. The line of
code that pulls the information is formatted as follows:
worksheet.range("A" & 2).value
The quickbooks portion is working correctly when only values are
entered. Thanks for any advice.

Getting result of formula instead of actual formula
 

Couple of questions...
Is "worksheet" a worksheet object variable, a sheet code name or
maybe a typo?
Is the entry in cell A2 a working formula or could it
be considered text by Excel?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"LoDawg"

wrote in message
I am working on a routine to send information from excel to a users
quickbooks company file. If the user has created a formula to calculate
the value of a cell when the import routine sends it to quickbooks it
sends the formula instead of the result of the formula. The line of
code that pulls the information is formatted as follows:
worksheet.range("A" & 2).value
The quickbooks portion is working correctly when only values are
entered. Thanks for any advice.

Getting result of formula instead of actual formula
 

Sorry for the confusion. worksheet is an object variable, and the entry
in cell A2 is of the format: =(U16/54) + 6.


Jim Cone wrote:
Couple of questions...
Is "worksheet" a worksheet object variable, a sheet code name or
maybe a typo?
Is the entry in cell A2 a working formula or could it
be considered text by Excel?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"LoDawg"

wrote in message
I am working on a routine to send information from excel to a users
quickbooks company file. If the user has created a formula to calculate
the value of a cell when the import routine sends it to quickbooks it
sends the formula instead of the result of the formula. The line of
code that pulls the information is formatted as follows:
worksheet.range("A" & 2).value
The quickbooks portion is working correctly when only values are
entered. Thanks for any advice.