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?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
dynamic link excel spreadsheet into atuocad
|
RE: dynamic link excel spreadsheet into atuocad
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
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
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
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
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
RE: dynamic link excel spreadsheet into atuocad
Mala Singh
'Dare to Imagine'