PDA

View Full Version : MsoAutoShape Binding Problem



jonasste
12-17-2015, 09:09 AM
Hi!

I think I'm having a binding problem. I have written a VBA code in Excel that creates some shapes. If I try to run the code on another PC I get the following error: "Can't find project or library", and it stops on this line of code:

If s.Type = msoAutoShape Or s.Type = msoLine Then s.Delete

Notice that this other PC is missing the Microsoft Office 16.0 Object Library. That's why I think it could be a binding problem.

Does anyone have a workaround for this? I've tried to find help on Google for late binding, but I did'nt find any help on msoAutoShape objects!

p45cal
12-17-2015, 09:51 AM
How is s assigned?

Aflatoon
12-17-2015, 09:53 AM
It shouldn't be possible for the Office library to be marked as 'MISSING:' in the references list. Is it definitely that library?