Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue in VBA functions
Hello, I have an application which has more than 200 VBA user define function. Some times, I get the error in recognizing the function whe I reopen the excel sheet which has functions. For example if m function in named as GetUserList, when I reopen the excel, It has a value "='C:\Program Files\Microsof Office\Office\LIBRARY\TNG\TNG_Write.xla'!" added to front of th function. I know this will happen, If I didn't open the add-in. But it happen after opening the addins also. Also it happens when this excel shee was created by one user and reopened by another user. Any answer on this issue is appreciated. Thanks Day -- Day ----------------------------------------------------------------------- Daya's Profile: http://www.excelforum.com/member.php...fo&userid=3028 View this thread: http://www.excelforum.com/showthread.php?threadid=49977 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue in VBA functions
Is the aforementioned path/filename the correct path/filename for th desired add-in -- MrShort ----------------------------------------------------------------------- MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218 View this thread: http://www.excelforum.com/showthread.php?threadid=49977 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue in VBA functions
Thats right, It has the actual addin file/path. -- Daya ------------------------------------------------------------------------ Daya's Profile: http://www.excelforum.com/member.php...o&userid=30288 View this thread: http://www.excelforum.com/showthread...hreadid=499778 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
nesting issue in functions | Excel Worksheet Functions | |||
Public Functions As Worksheet Available Functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |