Consulting

Results 1 to 3 of 3

Thread: MsoAutoShape Binding Problem

  1. #1
    VBAX Newbie
    Joined
    Jun 2012
    Posts
    5
    Location

    MsoAutoShape Binding Problem

    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!

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    How is s assigned?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,722
    Location
    It shouldn't be possible for the Office library to be marked as 'MISSING:' in the references list. Is it definitely that library?
    Be as you wish to seem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •