How to store formula in Access table ?
 

Hi

I have a table in Access and some fields have formula's stored.
Using 'Get External Data' in Excel, i need that the formula stored become in
a formula in Excel and not just a string.

How can i do it ?

How to store formula in Access table ?
 

The formula will come back as text. You need to reformat the cells to
general, and then do a find replace on the = sign to activate the formulas...
--
HTH...

Jim Thomlinson


"kleysonr" wrote:

Hi

I have a table in Access and some fields have formula's stored.
Using 'Get External Data' in Excel, i need that the formula stored become in
a formula in Excel and not just a string.

How can i do it ?

How to store formula in Access table ?
 

Jim,

When i use replace in menu Edit-Replace works very well.

But my code don't work
Worksheets(2).Columns("B").Replace What:="=", Replacement:="=",
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

What's wrong ?

"Jim Thomlinson" wrote:

The formula will come back as text. You need to reformat the cells to
general, and then do a find replace on the = sign to activate the formulas...
--
HTH...

Jim Thomlinson


"kleysonr" wrote:

Hi

I have a table in Access and some fields have formula's stored.
Using 'Get External Data' in Excel, i need that the formula stored become in
a formula in Excel and not just a string.

How can i do it ?