Saving Files into a Folder

[Justin Philips]

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

 

[Tom Ogilvy]

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.

 

[Justin Philips]

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







- Show quoted text -

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