You should always post your code for comments/suggestions Perhaps

activeworkbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike @ GD" wrote in message
...
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.