crpcsol
asked on
PowerPoint 2010 VBA AddTextBox Error
Hi,
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.AddTextb
Left:=intLeft, Top:=intTop, Width:=intWidth, Height:=intHeight)
It fails when I try both early binding and late binding techniques. Any thoughts?
Thank You
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.AddTextb
Left:=intLeft, Top:=intTop, Width:=intWidth, Height:=intHeight)
It fails when I try both early binding and late binding techniques. Any thoughts?
Thank You
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree
The poster needs to get back or byundyt's answer should be accepted
The code from byundyt works fine for me (Top, Left,Width and Height should technically be Singles not Integers but it works fine)
The poster needs to get back or byundyt's answer should be accepted
The code from byundyt works fine for me (Top, Left,Width and Height should technically be Singles not Integers but it works fine)
Not enough information to confirm an answer.