ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using add-in through intranet (https://www.excelbanter.com/excel-programming/312704-using-add-through-intranet.html)

Ajit

Using add-in through intranet
 
I have couple of files accessible/downloadable through intranet. I am
planning to
use Add-ins (some common set of code/functions, forms to be attached to all
the files).

Firstly, am i thinking the right approach/logic?

Secondly, Can i keep the add-in on the server and attach it to all the files
and use the form and code in the add-in's. And is there a way that when one
downloads a file to it's own PC and gets d'connected to the internet the
add'in utilities can still be used.

Suggestions will be highly appreciated.

--
Ajit

p[_2_]

Using add-in through intranet
 
Hello Ajit,

It is a bad idea to keep an add-in on a file server, as this will reduce
your network bandwith.

You could either use SMS to automate an update or you could attach a VBS
script to your user's login process so as to download the add-in to your
users machine.

If these computers have different folders/directories structures, then query
the registry so as to find the correct location to install/copy your add-in.

Hope that helps

"Ajit" wrote in message
...
I have couple of files accessible/downloadable through intranet. I am
planning to
use Add-ins (some common set of code/functions, forms to be attached to

all
the files).

Firstly, am i thinking the right approach/logic?

Secondly, Can i keep the add-in on the server and attach it to all the

files
and use the form and code in the add-in's. And is there a way that when

one
downloads a file to it's own PC and gets d'connected to the internet the
add'in utilities can still be used.

Suggestions will be highly appreciated.

--
Ajit





All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com