Use late binding to get at the FORMS library

Discussion in 'Microsoft Excel Programming' started by xp, Mar 25, 2009.

  1. xp

    xp Guest

    Using Excel 2007;

    I'm trying to use late binding to create a reference to the Forms library so
    I don't have to reference it in my code. The following does NOT work:

    Dim oData As Object
    Set oData = CreateObject("MSForms.DataObject")

    Can someone please correct the above form me so I can get at the
    "DataObject" library?

    Thanks.
     
    xp, Mar 25, 2009
    #1
    1. Advertisements

  2. xp,

    There is a discussion here that may be of use:

    http://www.mrexcel.com/forum/showthread.php?t=192500

    HTH,
    Bernie
    MS Excel MVP


    "xp" <> wrote in message
    news:...
    > Using Excel 2007;
    >
    > I'm trying to use late binding to create a reference to the Forms library so
    > I don't have to reference it in my code. The following does NOT work:
    >
    > Dim oData As Object
    > Set oData = CreateObject("MSForms.DataObject")
    >
    > Can someone please correct the above form me so I can get at the
    > "DataObject" library?
    >
    > Thanks.
     
    Bernie Deitrick, Mar 25, 2009
    #2
    1. Advertisements

  3. xp

    xp Guest

    I guess the ultimate answer is, you can't use late binding with "DataObject"
    so it's impossible; since it's not an ActiveX component.

    Thanks for the reference.



    "Bernie Deitrick" wrote:

    > xp,
    >
    > There is a discussion here that may be of use:
    >
    > http://www.mrexcel.com/forum/showthread.php?t=192500
    >
    > HTH,
    > Bernie
    > MS Excel MVP
    >
    >
    > "xp" <> wrote in message
    > news:...
    > > Using Excel 2007;
    > >
    > > I'm trying to use late binding to create a reference to the Forms library so
    > > I don't have to reference it in my code. The following does NOT work:
    > >
    > > Dim oData As Object
    > > Set oData = CreateObject("MSForms.DataObject")
    > >
    > > Can someone please correct the above form me so I can get at the
    > > "DataObject" library?
    > >
    > > Thanks.

    >
    >
    >
     
    xp, Mar 25, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris

    DAO objects with late binding in Excel?

    Chris, Aug 21, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    521
    Chris
    Aug 21, 2003
  2. jason

    EARLY binding or LATE binding ?

    jason, Feb 26, 2004, in forum: Microsoft Excel Programming
    Replies:
    6
    Views:
    1,687
    Tushar Mehta
    Feb 26, 2004
  3. Guest
    Replies:
    5
    Views:
    1,115
    Guest
    Apr 22, 2004
  4. Lee S

    Late binding to .XLA library??

    Lee S, Mar 3, 2005, in forum: Microsoft Excel Programming
    Replies:
    6
    Views:
    419
    Lee S
    Mar 4, 2005
  5. Guest

    Late Binding examples of binding excel application

    Guest, Mar 14, 2005, in forum: Microsoft Excel Programming
    Replies:
    14
    Views:
    3,716
    Bob Phillips
    Mar 17, 2005
  6. Piranha

    Late Binding or Late Anything

    Piranha, Oct 14, 2005, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    473
    Piranha
    Oct 15, 2005
  7. bony_tony

    Late Binding/Object Library Probelms

    bony_tony, Jul 27, 2007, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    258
    Guest
    Jul 27, 2007
  8. Henk

    From Early binding to Late binding

    Henk, Feb 12, 2009, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    503
    Bob Phillips
    Feb 12, 2009
Loading...