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