View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bura Tino Bura Tino is offline
external usenet poster
 
Posts: 57
Default Using function from vba add-ins: looking for a solution


"Jens Thiel" wrote in message
...
"Bura Tino" wrote
Solution 1 is unacceptable because it is good practice to put add-ins on

the
a shared drive so they can be upgraded invisibly to the users.


Have you tried updating the add-in while it is opened by a user..?


Actually yes, although it sounds bad. It's seems ok - they notice changes
when they restart excel.



A third solution that I will pursue if I get no suggestions is to

rewrite
the add-in in C++, since C++ add-ins seem to be free of this ridiculous
problem.

Does anyone have any suggestions?


I can give you an evaluation copy of ManagedXLL if you like to try that

;-)


Don't know what ManagedXLL is. I will look into that.

I could fake having an F: drive by mounting one of the
local directories. Does anyone one if this is possible? Sorry for the

OT.

use "SUBST F: C:\PATH\TO\ADDIN" but be warned: I remember we had problems
with that


What kinds of problems?

I've also discovered that you can mount it as \\127.0.0.1\SHARED_DIR



Jens.

--
http://ManagedXLL.net/ | http://jens-thiel.de/ | http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!