Reference / Binding Addin.xlam

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

Patrick Molloy

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


fir laet binding declare your varaibles as Object then

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

Barb Reinhardt

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")
 
P

Patrick Molloy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top