This article explains a few reasons you might be getting the error "ActiveX Automation: no such property or method".
This error is usually caused by a typo in one of the properties or method in the line indicated by the error. For example, this line would generate that error:
This is because there is a typo in the method. The method "Cell" should be "Cells", as seen in the WksRange object properties and methods.
If there are no typos in the line, this error could also be caused by using new properties or methods with an older version of Surfer. For example, this line would generate that error when run in Surfer 12:
MapFrame.CoordinateSystem = "World Geodetic System 1984"
This is because the CoordinateSystem property for the MapFrame object was added in Surfer 13. There is no such property or method in Surfer 12 (or prior).
If you are certain the line doesn't contain typos and is supported by the version of Surfer you are using, please email a simplified script that can be run in Scripter that exemplifies the problem to firstname.lastname@example.org.
Updated October 10, 2017