I actually found out the issue, I previously had a downloaded Rocksmith on my PC and the Mod Installer was installing in that folder. After I deleted that old Rocksmith folder I then re-ran the exe for the Mod Installer and it asked me for the location which I then moved to the Steam folder for Rocksmith and Viola!