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

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

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