Macro - save to current location vs excel default location
 

I have an Excel 2003 spreadsheet containing a macro to create new
spreadsheets. Here's how it works - Open WorkBook1, run Macro1, which
creates WorkBook2, Workbook3€¦etc. from WorkBook1.
This works great for one client. All of the created WorkBooks (2,3 etc..)
are created in the same folder as WorkBook1.
For other clients the WorkBooks (2,3 etc..) are created in the default save
folder for Excel not where WorkBook1 is located.
What is the difference?