Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert cell formula functions to code functions Adnan Excel Discussion (Misc queries) 1 October 1st 08 08:30 PM
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
nesting issue in functions Mike1 Excel Worksheet Functions 2 February 9th 06 06:08 PM
Public Functions As Worksheet Available Functions Steve King Excel Programming 3 February 12th 05 07:55 PM
excel functions and User defined functions Kanan Excel Programming 4 May 20th 04 11:21 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"