Add reference programmatically in VBA

Hi,

I want to use an external software called "Surfer" from vba. If I manually check "Surfer 10 Data Type" reference in vba, it works fine, but it requires me to check the reference library every time I open a new file. To do it programmatically I tried following commands:

ActiveWorkbook.VBProject.References.AddFromFile "C:\Program Files\Golden Software\Surfer 10\Surfer.exe"

ActiveWorkbook.VBProject.References.AddFromGuid "{54C3F9A2-980B-1068-83F9-0000C02A351C}", 1, 0

Any of these commands does check the reference library in vba, but the surfer command is not recognized. Is there any other line of code that I should write to make it work?

Thanks,
Nasser

Thanks Yasser for your time.

Unfortunately it does not fix it. I doubt it is a broken reference, i guess it might be the reference file being "exe" rather than dll; and probably it needs other tweaks as well as the GUID. or Office being 365!

I again very much appreciate your reply.

Nasser