AddTextbox Method Powerpoint Set or NotSet

Hi Jonas,

You're going to hate yourself for this one. The item in red below seemed to be missing. When I got it working the Shape was not in the visible area of my slide.

Please Login or Register  to view this content.

The following is text that I use for a shape:

Please Login or Register  to view this content.

You can avoid the error you had using 'Option Explicit'. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

hey lewis,

thanks! but unfortunately the misspelling is not the reason. I still get an "activex component cant create object"..... any other ideas whats going on? (I also tried your code and it gives the same error).

Thanks for your time!

Jon

Hi Jon,

My speculation is that you are missing one or more VBA resources. To see what resources you have enabled, in PowerPoint, access VBA and select: Tools > References. The references enabled on my computer are in the attached jpg file. Your version numbers (e.g. Office 11.0) will probably be a higher number because you have a later version of Microsoft Office.

If you are missing a reference or references, check the box for the appropriate reference.

If this doesn't fix the problem, I am stuck.

Lewis

I think I have all the necessary references.....maybe it has something to to with me running the code from vba embedded in excel, although Im am really careful referencing active apps, active windows etc.

maybe the complete code is helpful:

Please Login or Register  to view this content.

Same problem: method as it is works (AddtextBox(......).Select for example) but setting a shape obj with the method does not!

Thanks!

Hi Jon,

Excel and PowerPoint apparently don't recognize each other's objects such as 'PowerPoint.Application'. I got your code to work when I changed all objects to the generic 'Object'. Please note that the 'BLABLA' text is off the slide on my computer and in order to see it, I had to reduce zoom to 50% or 75%.

Try (changes in Red):

Please Login or Register  to view this content.

Lewis