Macro Linking to File name Based on a Cell Contents

[dusty9]

Hi, I'm trying to run a macro which plays a song that has the file name the same as my cell x4 contents. I found a macro to play a song if it is a constant hyperlink, but I can't get it to change the file name depending on my x4 cell.
Here is what I tried; where I put & Range("X4").value & is where I want the file name to have the X4 cell value.

FileToPlay = """C:\Users\Dusty\Desktop\New Folder\ & Range("X4").value &.mp3"""
Shell "C:\Program Files\Windows Media Player\wmplayer /play /close " & FileToPlay

Any help would be appreciated

 

[NeonRedSharpie]

[COLOR=#333333]FileToPlay = ""C:\Users\Dusty\Desktop\New Folder\" [/COLOR][B]& Range("X4").value & ".mp3""[/B]

 

[dusty9]

Thanks for the reply, looks like I might have just had quotations in the wrong spot but when I put in the line you posted, I get a Compile Error: Syntax Error
Am I still doing something wrong?

FileToPlay = ""C:\Users\Dusty\Desktop\New Folder\" & Range("X4").value & ".mp3""
Shell "C:\Program Files\Windows Media Player\wmplayer /play /close " & FileToPlay