Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
I'm using the Excel 4 REGISTER command to add argument descriptions to my
company's suite of UDFs and function categories to the Function Wizard (thanks in no small part to Jan Karel Pieterse). To stop duplication of these UDFs in the "User Defined" category (and 2 entries for each under "All" category), I can put Option Private Module at the top of each module containing my UDFs. This is great but these UDFs have been around for while and other people here will have coded all sorts of calls to them. What are the ramifications of my making these modules private? Could there be backward-compatibility problems with other people's code suddenly falling over? I know most people use this type of call: x = Application.Run("addin.xla!UDF",arg1,arg2) but there could be other types in use. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
Yes, adding Option Private could potentially cause problems. One scenario is
if a reference has been set to project procedures in private modules will not be visible, possibly other scenarios too. UDF's should continue to work though, as would app.run. I'm not sure which Excel4-Register method you are using but if you are using the workaround developed by KeepItCool I don't think you should have any issues with UDF's appearing duplicated in categories in the function list. http://www.jkp-ads.com/articles/RegisterUDF01.asp Regards, Peter T "Smallweed" wrote in message ... I'm using the Excel 4 REGISTER command to add argument descriptions to my company's suite of UDFs and function categories to the Function Wizard (thanks in no small part to Jan Karel Pieterse). To stop duplication of these UDFs in the "User Defined" category (and 2 entries for each under "All" category), I can put Option Private Module at the top of each module containing my UDFs. This is great but these UDFs have been around for while and other people here will have coded all sorts of calls to them. What are the ramifications of my making these modules private? Could there be backward-compatibility problems with other people's code suddenly falling over? I know most people use this type of call: x = Application.Run("addin.xla!UDF",arg1,arg2) but there could be other types in use. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
Thanks but in fact he himself says this is a problem (the duplicated entries).
"Peter T" wrote: Yes, adding Option Private could potentially cause problems. One scenario is if a reference has been set to project procedures in private modules will not be visible, possibly other scenarios too. UDF's should continue to work though, as would app.run. I'm not sure which Excel4-Register method you are using but if you are using the workaround developed by KeepItCool I don't think you should have any issues with UDF's appearing duplicated in categories in the function list. http://www.jkp-ads.com/articles/RegisterUDF01.asp Regards, Peter T "Smallweed" wrote in message ... I'm using the Excel 4 REGISTER command to add argument descriptions to my company's suite of UDFs and function categories to the Function Wizard (thanks in no small part to Jan Karel Pieterse). To stop duplication of these UDFs in the "User Defined" category (and 2 entries for each under "All" category), I can put Option Private Module at the top of each module containing my UDFs. This is great but these UDFs have been around for while and other people here will have coded all sorts of calls to them. What are the ramifications of my making these modules private? Could there be backward-compatibility problems with other people's code suddenly falling over? I know most people use this type of call: x = Application.Run("addin.xla!UDF",arg1,arg2) but there could be other types in use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Private Module (for Object Modules) | Excel Programming | |||
Option Private Module | Excel Programming | |||
Improve method of calling a private function in a private module | Excel Programming | |||
Option Private Module | Excel Programming | |||
Option Private Module not preventing cross project referencing | Excel Programming |