Hyperlink File Paths

[Barquentine]

I have inserted hyperlinks to mp3 tracks from a list of songs on an Excel spreadsheet - both the mp3 tracks and the spreadsheet are on a memory stick.
I copied all to the C-drive of a laptop - now none of the hyperlinks work because the file path says G:\ but the files are in a different drive now.
Is there a way to fix this?
thanks

[jeffa]

Right-click the cells with the hyperlinks, select Edit hyperlink, and change G:\ to C:\.

[Aquariel]

If you have a lot of cells to change, you can use a macro to automate it. Paste the following into a new macro, between the "Sub" and "End Sub" lines. Then just highlight all of the cells with hyperlinks in and run the macro. You can customise oldpath and newpath as required.

Dim link As String
Dim cell As Range
Dim oldpath As String
Dim newpath As String

oldpath = "G:\"
newpath = "C:\"

For Each cell In Selection

If (cell.Hyperlinks.Count) > 0 Then
link = cell.Hyperlinks.Item(1).Address
cell.Hyperlinks.Item(1).Address = Replace(link, oldpath, newpath)
End If

Next cell

[Barquentine]

Thank you Aquariel -that works a treat!