Thread: Code from Powerpoint VBE not Working in Excel VBE?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Aaron is offline
external usenet poster
  
Posts: 287
Default Code from Powerpoint VBE not Working in Excel VBE?
With a worksheet object selected in Powerpoint this code works perfectly from
PP VBE but from Excel VBE I get "Run-time error 429: ActiveX comonent can't
create object"

PowerPoint.Application.ActiveWindow.Selection.Shap eRange.Name = "testname"

Through tools references I have selected:
VBA
MS XL 11.0 obj lib
OLE auto
MS off 11.0 obj lib
MS PP 11.0 obj lib
and just for kicks I tried some MS ActiveX object libraies, but they did not
seem to help so I have deselected them now. Any ideas?



Reply With QuoteReply With Quote