Can I set a reference (from Autocad to Excel) programmatically

Discussion in 'AutoCAD' started by Dave F, Aug 19, 2003.

  1. Dave F

    Dave F Guest

    Hi

    A2k2, Excel '97 & 2000

    I've written a routine that pulls in info from an Excel worksheet.
    The 2 machines I use have different versions of Excel that use different
    versions of their object library.
    How do I reference the library that's required from within VBA.

    Thank in advance

    Dave F.
     
    Dave F, Aug 19, 2003
    #1
  2. Dave F

    Ed Jobe Guest

    I have a paper on the AUGI Exchange (www.augi.com) that explains how to do
    it. Look for EX001387.
     
    Ed Jobe, Aug 19, 2003
    #2
  3. Dave F

    gilbbs Guest

    hi guys, sorry to but in.
    Is there someway I can have autocad hold the values of my dwgs? I need this for a takeoff.
    Examples I have 15 fire hydrants
                                80 water service connections
                                Waterline is 1500' long e.g.
    Is it possible to use VBA? Or some other listings in Autocad 2004.
    Theirs got be a better way than listing lines and blocks.

    Thanks
     
    gilbbs, Aug 19, 2003
    #3
  4. Dave F

    Ed Jobe Guest

    Don't mind you butting in, but this really should be a new thread.




    --
    Ed
    --




    "gilbbs" <> wrote in message news:...

    hi guys, sorry to but in.
    Is there someway I can have autocad hold the values of my dwgs? I need this for a takeoff.
    Examples I have 15 fire hydrants
                                80 water service connections
                                Waterline is 1500' long e.g.
    Is it possible to use VBA? Or some other listings in Autocad 2004.
    Theirs got be a better way than listing lines and blocks.

    Thanks
     
    Ed Jobe, Aug 19, 2003
    #4
  5. Dave F

    Dave F Guest

    Excuse my ignorance, but what is cf ?


     
    Dave F, Aug 20, 2003
    #5
  6. Dave F

    Dave F Guest

    Jesus, got there in the end.

    That site must be one of the slowest, complicated & unuser friendly pages
    I've come across.

    The motto: 'We've got info, but we're going to make it damned hard for you
    to get hold of.'

    Dave F.
     
    Dave F, Aug 20, 2003
    #6
  7. Dave F

    Kevin Terry Guest

    i couldn't even find the 'advanced search' link - how did you end up finding
    this? can you post a direct link please?

    thanks,
    Kevin
     
    Kevin Terry, Aug 20, 2003
    #7
  8. Dave F

    Anne Brown Guest

    Customer Files (CF) is an area for upload of problem files for
    review or sharing. Users are asked to zip any files prior to
    uploading to conserve download time and server space.

    For NNTP newsgroup readers the Customer-files newsgroup can be
    found at
    news://discussion.autodesk.com/autodesk.autocad.customer-files.

    You may also access the customer-files group via the HTTP
    web-based forums at
    http://discussion.autodesk.com/WebX?14@@.ee940b5.
     
    Anne Brown, Aug 20, 2003
    #8
  9. Dave F

    Ed Jobe Guest

    They are working on a site redesign now.
     
    Ed Jobe, Aug 20, 2003
    #9
  10. Dave F

    Kevin Terry Guest

    thanks...

    Kevin

     
    Kevin Terry, Aug 20, 2003
    #10
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. Programmatically importing ADT styles

  2. load "TODAY" via programmatically help?

  3. skill to check and/or set VXL connectivity reference

  4. Can extracted, AutoCad attributes, be changed in Excel?

  5. AutoCad as OleServer - Programmatically embed images in DXF

  6. Can I create a block from a selection set?

  7. Selection Set - How do I select Block Reference Objects?

  8. Can I control the naming of .plt files when batch plotting from sheet set manager

Loading...