With
VB 2005, get into into the current, already open PowerPoint (Office 2003) presentation (and, for example get its name):
Dim ppapp As New PowerPoint.Application
MsgBox(ppapp.ActiveWindow.Caption)
It works. Then, why the same with Excel:
Dim xlapp As New Excel.Application
MsgBox(xlapp.ActiveWindow.Caption)
produces error "Object reference not set to an instance of an object"?
It bewilders me. How can I get into the Excel sheet that is already open?