Reference / Binding Addin.xlam

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

Hello!
I have a workbook that uses some procedures and functions wich, for
convenience reasons, I have stored in a seperate Excel Addin. The workbook
has a reference to said Addin and everything works Great!

HOWEVER....

Recently, and for convenience reasons again, I decided to sotre my Addin on
a server. Yet, when I try to create the reference to the workbook, who's path
is now "http://Myserver/blah.xlam", I get an error message saying Visual
Basic cannot add a reference to the file. How should I go about solving this?
Maybe via Late binding? If so, could someone help me with the code? Other
Alternatives?

Any advice GREATLY appreciated.
Thanks in advance,
Albert C.
 
servers are usuall \\serverbane\sharename\...


fir laet binding declare your varaibles as Object then

DIM oMyObject as Object
Set oMyOject = CreateObject("appname")
 
Sharepoint sites have a url like http://...

Patrick Molloy said:
servers are usuall \\serverbane\sharename\...


fir laet binding declare your varaibles as Object then

DIM oMyObject as Object
Set oMyOject = CreateObject("appname")
Click to expand...
 
Back
Top