Detect new drive if main folder is moved

Good Morning Folk

I am trying to use a macro to link a file to a button on a workbook page, It will, sometimes need to be moved to a new drive

I recorded a macro to open the workbook within a folder and as you can see it puts in the drive path, in this case 'C'. I need it to automatically work on any drive not just C, The folder, workbook and filename, structures will not change, just the drive

Many thanks for your help

Please Login or Register  to view this content.