Macros not Working in Word2007

[StephenW832]

Hi,
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?

Thanks,
Steve

[Jupiter 2]

You need "FileFormatConverter.exe" (See attached zip)
It allows you to open any Office 2007 file in Office 2000

I got it from the Microsoft Site.

When you click the exe, you get the usual run around.
Click "Yes Install , Yes ok ok ok Just do it already".
Windows will set a restore point.

[Jupiter 2]

It allows you to open any Office 2007 file in Office 2000

It allows you to open any Office 2007 file in Office 2003

=========================================
Also, my references are still using the MSExcel 11.0 Object library where as the clients are using MSExcel 12.0 Object Library.
Your clients may have "MSExcel 11.0 Object library" they only have to check their references and checkmark it.

[Jupiter 2]

Your clients may have "MSExcel 11.0 Object library" they only have to check their references and checkmark it.

Oops! You can only have one object lubrary loaded at any one time!!!

About that other problem. Do you use an addin that refers to the server? If so, unload it, create an addin loader for that addin and put that code just before the request for files in the macro.

Before the program exits, unload the Addin.