LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default SIMPLE way to call code in one XLA from another?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Code - Simple Code Fix? J.W. Aldridge Excel Programming 2 April 4th 08 02:24 PM
call VB code on refresh. GS80 Excel Programming 1 March 18th 08 09:26 PM
how can i call sub or function in vba code xxx Excel Discussion (Misc queries) 3 June 28th 06 11:47 AM
Code in one workbook to call code in another XL file [email protected] Excel Programming 2 August 1st 05 03:37 PM
call VBA compiled code within vba Les[_5_] Excel Programming 1 September 26th 03 06:27 PM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"