TransferSpreadsheet and Formulas

[bjd4jc]

I am wondering if anyone knows a way of creating formulas with the TransferDatabase method. This is what I've done to test.

I am using Access XP and Excel XP. I create a table called Table1. Created a field Called TestFormula. The value of the field I set as "=4+5" (without quotes). I do the TransferSpreadsheet method and when I open up the new excel sheet the value of the first cell is "'=4+5" and so it actually displays "=4+5" in the cell instead of 9.

Is there anyway for the formula to stay a formula and not be converted to text?

 

[MichaelRed]

Being a big !Excel fan, I'm certainly not the best resource for this. I DO know that it can be accomplished (sort of). It was discussed in some of htese forums and the conclusion was that all you really needed to to was force a recalculation of the Excel sheet after the export. Beyond that, I do not rember the details of what 'they' did.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over