Mark is suggesting that you *first* set the smaller files together, then use
the macro on that file, which will work if everything is as you have
A join B
A join C
A join D
is identical to
A join (B union all C union all D)
as long as there aren't duplicate IDs or whatnot causing problems [which
will cause problems in either case, probably]. So if your macro expects A
join Z only, then just make a Z that is B union C union D.
On Tue, Nov 10, 2009 at 3:28 PM, Cornel Lencar
> Hi Mark,
> The original file was broken in smaller, by year files, that I have to
> work with and the original macro was written for exactly that situation.
> Now I need to work with several smaller files, merge them individually
> with one file and the resulting files put them together in a unique final