how to approach this?

Originally Posted by iori

can anyone tell me how this should be done. i have an excel UDF(user defined function) used as a formula on some cells, inside this function depending on the values it is passed i need to access database and get updated values. I m fairly new to excel vba but have good programming experience. I would like to know before attempting if its even possible inside a function when its being used as a formula. Previously i wasted my time getting a value from another workbook inside of a function only to find out it wasnt possible inside a function when its used in a formula.

any help in this matter will be appreciated.

A value from another workbook is possible inside a udf, an extract from one of my udf is

Please Login or Register  to view this content.

where Concat is the Function name, and the value from A1 in the stated workbook is appended to myStr for a full display.

Hope this helps.
---