Hi,

I have created a quote template that ultimately gets saved to a network
drive. I know I can have VBA automatically save to a specific folder that I
program.
My question is, my group saves this quote in a particular folder based on
order #. So I have about 10 different folders that it could potentially be
saved in, based on where the order # falls. For example, the order # is
30256-10. The "-10" of the order # makes no difference. Therefore this file
would be saved in the 30000-39999 range. There are folders with ranges of
20000-29999, 30000-39999, 40000-49999 etc.. How can I have VBA analzye the
sales order # (say in cell L10) and save to the appropriate folder (this case
30000-39999). These folders would be located in G:\server1\orders.

Thanks for any help.