Hi, i found interesting issue. I already solved it, so this is not a question, but just my observation. I think it could help someone else, because even Google gave me no answer.

I have two macros. One macro, lets say Macro_1, open PowerPoint and insert some data into presentation. Second macro Macro_2 runs first macro in batch (uses Application.Run Macro_1), so more presentations can be updated by one click. I use Excel 2003, PowerPoint 2003 or 2007. At my and lot of computer this project works fine, but one computer fails when attepts to run macro_1 from macro_2. It crashed with run-time error 1004: Macro cannot be found. I tried to rename and move file with macro_1 (no spaces, special characters at file name, folder name, etc..), put file name into single quotes like Application.Run "'file.xls'!Module.Macro_1", but nothing helped.

I noticed that problem computer doesn't have PowerPoint 2007, so I removed reference to Microsoft PowerPoint 12 Library at Macro_1 file. This helped a little, project has stopped work on all computers, known error 1004: Macro cannot be found. On my computer, where is both version of PowerPoint 2003 and 2007 installed, I cant find Microsoft PowerPoint 11 Library (for PowerPoint 2003) in the references list. I had to add it manually by Browse button, added C:\Program Files (x86)\Microsoft Office\OFFICE11\. This overwrited the reference to the PowerPoint 2007, so it is no more needed at my project.

Interesting is that macro was stopped on 1004: Macro cannot be found, and not the lack of reference to the PowerPoint 2007 or whatever.

What do you think?