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

Option Explicit

Sub Compliance_Access()

    ChDir "C:\Compliance Information\SOPs"
    Workbooks.Open Filename:= _
        "C:\Compliance Information\Compliance\Compliance Access.xls"
        
End Sub