| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Pls, how to convert an addin xlam file to xls worksheet in | Excel Discussion (Misc queries) | |||
| Late Binding access reference in Excel Module | Excel Programming | |||
| Late Binding examples of binding excel application | Excel Programming | |||
| VBA References - when is Office Object Library Reference set? Best practice re. Early/Late binding ... | Excel Programming | |||
| EARLY binding or LATE binding ? | Excel Programming | |||
Hybrid Mode
