Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using multiple XLTs
I have a series of macros that clean up about 20 different report files
stored in spreadsheets. All the code is currently stored in one XLT. I'd like to be able to store the code for each report in its own XLT with the common code in another XLT (21 XLTs in total) so that mutiple developers could modify individual report code w/o stepping on one another. Is it possible to invoke code in one XLT from another XLT? Thanks Carl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using multiple XLTs
Yes, using
Application.Run -- Regards, Tom Ogilvy wrote in message ups.com... I have a series of macros that clean up about 20 different report files stored in spreadsheets. All the code is currently stored in one XLT. I'd like to be able to store the code for each report in its own XLT with the common code in another XLT (21 XLTs in total) so that mutiple developers could modify individual report code w/o stepping on one another. Is it possible to invoke code in one XLT from another XLT? Thanks Carl |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using multiple XLTs
Tom
Thanks for the feedback. Are there any memory or other resource issues I should consider before doing this? I need to start the macro running and then invoke macros in other XLTs from within a loop. Each report averages about 500 lines of macro code and they'll need to invoke the common routines in another XLT many times over. Thanks Carl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |