×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

dynamic link excel spreadsheet into atuocad

dynamic link excel spreadsheet into atuocad

dynamic link excel spreadsheet into atuocad

(OP)
How do I setup a dynamic link between excel spreadsheet and autocad and back again?

RE: dynamic link excel spreadsheet into atuocad

You can use GetObject or CreateObject to interact with a VBA-compliant application from within another.

For example, If you wish to access Excel from within AutoCAD, the snippet of code in an AutoCAD module might go something like this...

Dim XL as Object
Set XL=CreateObject("Excel.Application")

Once you have done this Excel will open

Continue with code like...

Dim Wkbk as XL.Workbook
Set Wkbk=XL.Workbooks.Open("C:\MyDocuments\MyWkBk")

and so on...

There's much more to this - but this'll get you started.
Read the VBA help and see the examples therein.


Mala Singh
'Dare to Imagine'

RE: dynamic link excel spreadsheet into atuocad

Reading your post again, I feel I might have missed your point - if so, my apologies...

Maybe you mean Object linking and embedding (OLE) - the way to do this is to copy from one application and paste it into the other using PasteSpecial with the 'Link' checkbox selected.


Mala Singh
'Dare to Imagine'

RE: dynamic link excel spreadsheet into atuocad

(OP)
This is what I would like to do. An engineer makes up a specification sheet in excel about the materials to be used on a job. I would like to have a dynamic link to that spreadsheet in autocad on our cover sheet, however after the cover sheet is made and the engineer changes the spec's, I would like the drawing to check and see if the info is the same, and if not automatically update to the new information.
 Then the second thing I would like to accomplish is to take our bill of materials and kick it out to a spreadsheet for an early steel order form. At this point the spec sheet is more important, as this gets frequently overlooked.

RE: dynamic link excel spreadsheet into atuocad

I recently saw a product of this kind on the net - the link is:
http://www.cadaddon.com/cgi-bin/
and the name of the product is 'AutoXlsTable'

You can even see an online demo of how it works.

Good luck!


Mala Singh
'Dare to Imagine'

RE: dynamic link excel spreadsheet into atuocad

However, the PasteSpecial suggestion mentioned in my second post will still work.
1.Select the relevant range in the specs worksheet
2. Hit ctrl+c to copy to clipboard
3. Switch to AutoCAD
4. From the Edit menu item select PasteSpecial
5. In the dialog box that appears select Microsoft Excel Worksheet, make sure the Paste Link checkbox is checked.
6. Click OK to dismiss the dialogbox.

After you have done this, you can resize the embedded range.
Change some values in the worksheet to verify if the changes are reflected in the dwg.

Caution: If you move or rename the workbook the link will break.


Mala Singh
'Dare to Imagine'

RE: dynamic link excel spreadsheet into atuocad

(OP)
Thanks for your help the OLE worked w/spec's, we are currently working on extracting attribute text right now for the B.O.M.

RE: dynamic link excel spreadsheet into atuocad

Glad to be of help - and grateful for your gratitude!!


Mala Singh
'Dare to Imagine'

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources