I have a macro to update inventory in the workbook the macro is written in,
however when saved with a new name the macro will not work. How should the
macro be written to update saved files that are kept in the same folder. The
folder name is "Quote Workbook", the file names will range from 630000 to
659999.