How to store formula in Access table ?

  • Thread starter Thread starter kleysonr
  • Start date Start date
K

kleysonr

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 ?
 
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...
 
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 ?
 
Back
Top