vfp-9 ole word automation error with word 2010/acrobat x
I have a VFP app that uses OLE word automation to merge data and create/print documents. It has worked for years with WIN-XP and Office-2003 with Acrobat Standard-6.
We are now upgrading to Win-7 and Office-2010 with Acrobat Standard-X (10). Even after many internet searches and changes to Word settings, etc., my program will not run and returns error #1429. It keeps saying 'unable to run the specified macro', which is Adobe PDFMaker. yet the macro is listed in the Word Add-Ins and everything looks OK. I have also checked "enable ALL" macros in Word AND downgraded Office-2010 to the 32bit version.
Here is the code:
oWord = CreateObject("Word.Application")
.Documents.Open((M_Doc)) && Open Copy of Master
.Documents((M_Doc)).MailMerge.Execute && Run the merge
.Documents((M_Doc)).Close && Close Copy of Master
.ActiveDocument.SaveAs(sys(5)+ALLTRIM(M_NewLoc)+ALLTRIM(M_NewName)) && Save new Document
.Visible = .T. && View for editing/printing/re-saving/closing
Any help would be greatly appreciated - really in a bind here.
How the Word macro uses Adobe Acrobat? I suppose via OLE automation. Then you have to use Adobe Acrobat Professional because the Standard version does not support OLE automation.