Reference / Binding Addin.xlam
 

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.

Reference / Binding Addin.xlam
 

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


fir laet binding declare your varaibles as Object then

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

"Albert" wrote:

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.

Reference / Binding Addin.xlam
 

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

"Patrick Molloy" wrote:

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


fir laet binding declare your varaibles as Object then

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

"Albert" wrote:

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.

Reference / Binding Addin.xlam
 

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

"Barb Reinhardt" wrote:

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

"Patrick Molloy" wrote:

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


fir laet binding declare your varaibles as Object then

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

"Albert" wrote:

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.

Reference / Binding Addin.xlam
 

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


"Patrick Molloy" wrote:

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


fir laet binding declare your varaibles as Object then

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

"Albert" wrote:

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.