Retrieved Excel Cell values containing Excel Formulas are returned Empty.

Discussion in 'AutoCAD' started by clarence_rollins, Jun 19, 2004.

  1. clarence_rollins

    clarence_rollins Guest

    AutoCAD 2004
    Excel 2000
    Windows 2000/XP

    I am trying to retrieve the displayed values of Cells containing the
    following formula: '=SUMIF(OFFSET(INDIRECT(V7),0,-10), H7,OFFSET(
    INDIRECT(V7),0,-11 ))').

    The value is displayed correctly in the Worksheet, but when I try to read
    the value using AutoCAD VBA the value returned is empty.
     
    clarence_rollins, Jun 19, 2004
    #1
  2. clarence_rollins

    clarence_rollins Guest

    I'm referencing Exel's object library.

     
    clarence_rollins, Jun 20, 2004
    #2
  3. clarence_rollins

    clarence_rollins Guest

    Values are returned for Cells containing simpler Excel formulas (e.g.
    =A1+23).
     
    clarence_rollins, Jun 20, 2004
    #3
  4. clarence_rollins

    Tim Badger Guest

    Clarence, I don't know enough about excel to personally help you, but I
    found when I need to get information about it, the
    autodesk.autocad.connectivity discussion group is great for this kind of
    stuff.

    Hope I helped

    Tim
    tbadger at adlandsys dot com
     
    Tim Badger, Jun 21, 2004
    #4
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.
Similar Threads

  1. Identifying attribute containing a field

  2. LVS with a schematic containing variables

  3. Is it possible to delete empty column and cell in SW2005 design table?

  4. Drawing table values linked to values in design table?

  5. acadapp.version property - returned values

  6. Calculations or Formulas

  7. Can XData be retrieved and set using ObjectDBX?

  8. Need Help with Formulas...

Loading...