I created a group of macros in Word 2003 and they have been working fine. Recently a client upgrade to Office 2007. I went in and changed all the Application.FileSearch commands that I had in my macros, knowing that that command was no longer supported. But when I try to run the macros either from a shortcut or from the Add-in Ribbon menu I get an Error 5111 "This command is not availible on this platform". The macros run a shell ftp to copy a file from a UNIX server to the client hard drive and then does a Word mail merge using the transferred file as the data file.
If I open the template file (.dotm) in Word first and then run the macros from the menu they run without a problem.
The macros run fine on my developement PC. The one difference is that I have both Office 2003 and Office 2007 installed on my PC and the client installed an Office Standard Upgrade on their PC's. I have an older version of Office 2007 (12.0.6331.5000 SP1 MSO 12.0.6320.5000) where as the clients are running the latest (12.0.6425.1000 SP2 MSO 12.0.6425.1000).
Also, my references are still using the MSExcel 11.0 Object library where as the clients are using MSExcel 12.0 Object Library.
To run the macros from a shortcut I created a small exe in VB6.0 which accepts two parameters, checks those parameters, starts Word and using the parameters runs the a macro.
Anybody know what is tripping this up?