Very simple problem.
I've exported a geoprocessing script to vbs from Model Builder. Opened Excel > Create Macro (VB opens) > paste vbs code in > hit run, and get an 'object required' error on the first line:
Set gp = WScript.CreateObject("esriGeoprocessing.GPDispatch.1")
I'm assuming I need to import/include the path to a com library or dll for VB to recognize.
I saw a code snippet that accesses a method with a guid, but I doubt that's the right approach.
Thanks in advance, very much!
ps: I'd be using python but there is a small portion of vb that get exported into the python script and I can't find a python geoprocessing api to replace the vb code