S
SyZyGy
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
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