Using multiple XLTs

  • Thread starter Thread starter seton.software
  • Start date Start date
S

seton.software

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save Special Filename Multiple Times 1
Shortcuts created on root 1
Excel Subtracting multiple columns from another column 3
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Modify working code to expand the output. 5
Pull data (sumif?) from an external workbook 1
Access Sorting and grouping using multiple tables 0
VBA Code and Pivot Tables 4

Back
Top