Macro Auto update for new HD letter

[JamesT1]

Hi Folks

I have two spreadsheets on my hard drive, the HD drive letter is 'C', they linked and are updated through a recorded macro with an update button

Sometimes I move them onto the lap top and need to manually adjust the macro to accomadate the new hard drive letter, the vice versa when I move it back.

Is there a way I can adjust the macro for it to automatcally update to the new letter when I move it

Cheers

[shg]

Use a relative path?