I developed an MS Excel script that automates the addition and placement of text boxes in PowerPoint slides, and populates those text boxes with Excel data. The script works fine in Excel 2007. But, when I try running it in Excel 2010, I get the following Error: “The remote server machine does not exist or is unavailable.” The error occurs specifically on the line where a new text box is added to a slide:
Set objPPTextBox = objPPSlide.Shapes.AddTextbox(Orientation:=msoTextOrientationHorizontal, _
Left:=intLeft, Top:=intTop, Width:=intWidth, Height:=intHeight)
It fails when I try both early binding and late binding techniques. Any thoughts?