This is a little complicated to explain:

I have a report that is run once a week. On that report, the data for
three buyers is what I want. I have a folder for each buyer. The
buyers have some of the same venders, so I need to make sure that the
venders go into the correct buyer's folder or they will save over each
other. The problem is that there are 40-ish venders for each buyer
and the only way I know to have the venders be saved into the buyer's
folder is to have a Save As dialog box pop up. It takes forever and
is incredibly annoying for this to happen. I have recorded a macro to
automatically save to a folder, but the path is always changing
because we use ID numbers. How can I make sure that the vender will
be saved to the buyer's folder?

Thanks in advance!!!