Hi,

I have sent a file with macro for my colleagues' use. However, some
reference data have to be updated periodically. How can I set the macro in
the existing file for updating the reference file sent at regular interval
without knowing the path name he is going to save the reference file for
update to the existing file ?
I think I can insert a dialogue box asking him to select the path when the
existing file macro is triggered.
Is there better way to cope with that without having to choose the path each
time ?

Your contribution is highly appreciated.

Regards,
Frankie