What language is the macro written in e.g. is it SAX basic which is the default language for SPSS script?
Is the macro run as a SPSS syntax or SPSS script or vba run from Office?
Does the macro have stuff like
"Dim objSyntaxDoc As ISpssSyntaxDoc"
or "= InputBox$"
Need more clarification.
Any solutions I provide on this forum are free of charge, donations go towards the maintenance of the unaffiliated SPSS forum.