ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reading Functions from Common Place (https://www.excelbanter.com/excel-programming/335849-reading-functions-common-place.html)

pp

Reading Functions from Common Place
 
Hi All

I have a question with regards to usage of "COMMON Functions / Sub Routines"
from VBScript of excel file
We have bunch of COMMON routines which we would like to Save in single
Module File and refer this module across each of XLS files within that folder

Is that possible. If so, can somebody please tell me how it is done.

Thanks
PP

Kaak[_28_]

Reading Functions from Common Place
 

In the new version of Visual Studio there are tools for offic
application development.
You can put your COMMON routines in there ( in vb.net or C#.net) creat
a .dll file
and put a reference to that file in each workbook.
When you add routines to the .dll everybody is automatically updated.

If you have more questions about this let me know

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=39121



All times are GMT +1. The time now is 03:59 AM.

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