VBA reference to MSOWC.DLL

Discussion in 'AutoCAD' started by Mark Johnston, Feb 9, 2005.

  1. I am experiencing a problem when I use the MS Office Spreadsheet control
    (9.0) in my AutoCAD VBA apps.
    Our computers have MS Office installed.
    The references seem to be in tact but an error is displayed when code runs.
    The error says that a variable has not been defined. In fact, the variable
    is defined as public in a code module.
    If that error is cleared another error reports that a function is unknown
    but the function has a public scope and is in a code module.
    I check the References but there are none missing or broken.
    Our computer systems (20 of them) are nearly identical but this problem does
    not occur on all systems.

    What might be causing these errors?
     
    Mark Johnston, Feb 9, 2005
    #1
  2. Mark Johnston

    FXCASTIL Guest

    Mark,

    I use this the owc10.dll control to avoid problems I give every
    user the same copy of the owc10.dll and have them install it in the same directory. the they must usee regsvr32 to register it. I also include a reference to this dll file in the
    autocad vba ide which must be the same directory for each user. what are you using this owc.dll for
    you can e-mail me at
    if you want

    fred c
     
    FXCASTIL, Mar 1, 2005
    #2
  3. I'm using the Spreadsheet control for data input on a form.

    I'm not sure that msowc is the problem. I might have some systems where the
    dll doesn't get registered properly.

    directory. the they must usee regsvr32 to register it. I also include a
    reference to this dll file in the
     
    Mark Johnston, Mar 1, 2005
    #3
Ask a Question

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.