Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a function in another project from within a cell formula
Hi All,
I am running into an interesting problem and I was hoping that there was an easy solution. I have a personal.xls spreadsheet that contains a set of functions and subroutines. I have created a function in that spreadsheet that I want to use across moany other spreadsheets. When I try to use it in a formula within a cell, I get back #name? unless the function is defined within the project specific to the spreadsheet. What am I doing wrong here? Thanks in advanc for any help. Ellis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a function in another project from within a cell formula
Hi, Ellis!
Try coding the formula like this: =personal.xls!your_function(some_parameter) The personal.xls workbook must be open for this to work. Regards, Wes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a function in my SQL-DB from VBA | Excel Discussion (Misc queries) | |||
Calling a function and then returning | Excel Discussion (Misc queries) | |||
calling a function | Excel Programming | |||
problems calling this function | Excel Programming | |||
Calling a function from within EXCEL | Excel Programming |