Does anyone know the syntax for calling a macro in Word 2007 using FMPA v10? I've tried "run[(\"macro1\")] and although this worked fine in word XP (or maybe 2003?) it generates the error "complie error: sub or function not defined" in visual basic.
OK, I've solved it. For anyone wanting to know, the answer is to enter "[Macro1]" as the command in the DDE execute script step. I haven't tested this yet in Excel 2007 but I would assume it has also changed from prior versions.