Hi,

I have a macro in an Excel file that opens and closes a few other Excel files to update formulas, then opens a ppt presentation and triggers another macro in that one;
=> That macro opens, beside the Excel_file where the macro is, one more and updates some linked graphics. Then it publishes a backup in pdf format and ends;
=> Back in the Excel_file, the macro closes the remaining files and last closes itself, so that only the ppt remains open.

What happens is this: The macro runs fine, but while the ppt is updating the graphics, Excel displays a dialog "Excel is waiting for another application to complete an OLE transaction" or so.
This dialog just has one button, > OK <.
At first, this does not hinder things. The macro actually finishes all right - only those last Excel_files remain open in spite of the code to close them - only once I have clicked on the button, they all close and that is that.

=> Is there some way that I can insert a code in the macro to automatically confirm that dialog?

Thanks a lot!

Best regards,

Officer_Bierschnitt