I need to add this value to a specific cell then "hard code the results" . Basically the results replace this value. The macro below is from the Goldmine software link with excel. If you use this link currently it replaces the data each time you open the file with the current data in goldmine. I might have 20 of these macros per worksheet.
=TRIM(GMMacro("CONTACT2->UCLICKTH0")) goes in A1
=TRIM(GMMacro("CONTACT2->UCLICKTH1")) goes in b5
=TRIM(GMMacro("CONTACT2->UCLICKTH2")) goes in c 3
=TRIM(GMMacro("CONTACT2->UCLICKTH3")) goes in d 4
I in-vision a script that will auto populate all the macros the somehow remove themselves once the data is populated.