I am looking for a macro to save an updated file (created from an older one
using a macro) in the same directory as the original. The newer file will
then transfer some of the data from the older file to the newer.

When I run the macro I created on my own PC from the directory where the
original file was created all is fine - new file created in same directory,
data transferred.

The problem starts when I transfer the file to another computer or even a
different directory and run the macro from there. The new file is still
created, but it appears in a different directory to the original and hence it
cannot identify where the original file is located.

Is there a macro to say 'create file in same directory as the old one'?

Putting in a specific path would not work as there is no guarantee that when
the file is transferred it will be in a specific location

Any help appreciated