| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel user enter a store # to query Access data base | Excel Discussion (Misc queries) | |||
| Store Data in Access | Excel Programming | |||
| Store Excel Results in Access | Excel Discussion (Misc queries) | |||
| Store sheet names in Access | Excel Programming | |||
| Access data base is able to store any number of records | Excel Worksheet Functions | |||
Hybrid Mode
