Reference / Binding Addin.xlam

[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.

 

[Patrick Molloy]

servers are usuall \\serverbane\sharename\...


fir laet binding declare your varaibles as Object then

DIM oMyObject as Object
Set oMyOject = CreateObject("appname")

 

[Barb Reinhardt]

Sharepoint sites have a url like http://...

servers are usuall \\serverbane\sharename\...


fir laet binding declare your varaibles as Object then

DIM oMyObject as Object
Set oMyOject = CreateObject("appname")

 

[Patrick Molloy]

sure, but since that didn't seem to work, I was offering an alternative.

 

[Albert]

Thank you Patrick.
How should I get the statement

Set oMyOject = CreateObject("appname")

to point to the file I have on the server?
("http://Myserver/blah.xlam")

Thank you,

Albert C