Is anyone having trouble with Word 2007 automation? I am using code from "Microsoft Office Automation with Visual Foxpro. I had no problems with Word2000 or Word2003. I print 2 memo's, one is a cover letter with addressee data inserted. The other inserts the same addressee data and inserts data about a data embedded query using another data source. As I said, this was working great until we upgraded to Office 2007.
Now I am getting "Word cannot open document as a data or header source because it contains no data." after I have cleared old data. The next process, before the mailmerge execute, I open the headersource (works fine), then I open the datasource and get "File in Use, document is locked".
No, no one else has the doc open, I checked WinExpl to find the doc closed but a reference to it with the "~" (weird). I have tried different Word objects using parameter 9 and 10, but no difference. Any ideas?
Chuck
Extreme Programming = Plan -> Design -> Code -> Test