In excel, I have a textbox called textbox3.
In ppt, I have a textbox called TxtFootnote.
In vba, I am trying to populate TxtFootnote in ppt with the text from textbox3 but it keeps failing.
Can someone help me with this as it is doing my head in?
Set oPPTShape = oPPTFile.Slides(SlideNum).Shapes("TxtFootnote")
oPPTShape.TextFrame.TextRange = ActiveSheet.TextBox3.Text