Calling powerpoint module from excel macro

[swapnilushinde]

Hello

I am trying to call powerpoint macro from excel macro. Sometimes it works, sometimes not.. I am not sure what is happening..



Set powerpt = GetObject(, "powerpoint.Application")

MsgBox "In ppt call point"

MsgBox powerpt.ActivePresentation.Name

powerpt.ActivePresentation.Application.Run "InitializeApp"

'powerpt.Run "Module1.InitializeApp"



I am executing above code on workbook_open event.

Please help me to solve this issue..