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 explained it.

A join B union all A join C union all 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.

-Joe

On Tue, Nov 10, 2009 at 3:28 PM, Cornel Lencar <clencar@interchange.ubc.ca>wrote:

> 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 > file. >