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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Chris

    DAO objects with late binding in Excel?

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

    EARLY binding or LATE binding ?

    jason, Feb 26, 2004, in forum: Microsoft Excel Programming
    Replies:
    6
    Views:
    1,929
    Tushar Mehta
    Feb 26, 2004
  3. Guest
    Replies:
    5
    Views:
    1,297
    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:
    564
    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:
    4,363
    Bob Phillips
    Mar 17, 2005
  6. Piranha

    Late Binding or Late Anything

    Piranha, Oct 14, 2005, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    590
    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:
    322
    Guest
    Jul 27, 2007
  8. Henk

    From Early binding to Late binding

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