Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to greatly reduce the amount of code that is copied into
various VBA containers but is otherwise identical. This includes things like calculating holidays, figuring out who the user is, and various utilities like "WorksheetExists". I've given up on trying to make a truly universal one that will work in Excel and Access (am I missing something?) so for now I'm concentrating on Excel. I have about 20 modules in one huge code library. I want to break this down, and move all the truly generic utility code into a new XLA called, oddly enough, "Generic". This code rarely changed. That code will then be called from another broken-out library called "accounting". This code changes much more often. The problem is that, from what I can see, subs and functions in one XLA are invisible to another. I have seen code for calling it using RUN, but that is extremely ugly. Is there some other way to more directly call another module, like... Generic.WorksheetExists("myWorksheet") Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Code - Simple Code Fix? | Excel Programming | |||
call VB code on refresh. | Excel Programming | |||
how can i call sub or function in vba code | Excel Discussion (Misc queries) | |||
Code in one workbook to call code in another XL file | Excel Programming | |||
call VBA compiled code within vba | Excel Programming |