Took me ages to work out but the drivers need to be installed properly in order for it to work
https://www.ftdichip.com/Drivers/VCP.htm
I finally found the correct driver through trial and error and it is a manual install, choose the latest driver only!