force xcel to interpret text from access as a function
Posted by Trevor on January 08, 2002 10:53 PM
I get data from an access data base and view it in excel
It would be great if functions typed in a field in access worked when sought refreshed from the access.
eg. an access field is a list of excel functions.
However when I tried it it refreshed in excel as data only. I created a macro to convert to operable function , but it would be good if I could format the receptive excel cell so that it automatically acknowledged it as a function.
Have I confused others as much as I am??