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!!!

you would have some master list that you lookup the vendor and see which
buyer or buyers the vendor's information needs to be saved to. Make your
path a variable and use that infomation to populate the path variable with
the correct folder.

--
Regards,
Tom Ogilvy




"Justin Philips" wrote:

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!!!

On Aug 9, 2:08 pm, Tom Ogilvy
wrote:
you would have some master list that you lookup the vendor and see which
buyer or buyers the vendor's information needs to be saved to. Make your
path a variable and use that infomation to populate the path variable with
the correct folder.

--
Regards,
Tom Ogilvy



"Justin Philips" wrote:
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!!!- Hide quoted text -

- Show quoted text -

Is there a way to programmatically make folders and then to save to
those folders?