VBA and Object. Dbx - Auto. CAD to Excel Attribute Extraction Tool . This issue occurs if you have multiple Paperspace tabs with the specified block inserted in each tab. QUESTIONS: Has anyone out there been able to resolve Issue #2 using Object. Dbx? or. Will I need to go through the Auto. CAD interface and generate selection sets somehow? ATTACHMENT: I attached my Excel file to this posting for reference. It is a very useful tool given the above issues. I am sure that it could have been a little cleaner but at least I have some commenting. Feel free to post questions or comments regarding the program and I will do my best to answer them. Notes: - In Excel VBA, need to reference: Microsoft Scripting Runtime, Auto. CAD 2. 00. 8 type Library, Auto. CAD/Object. Dbx Common 1. Type Library- Compatibility: Auto. CAD 2. 00. 8, Excel 2. AutoCAD Doors & Windows Block Library Preview The ArchBlocks AutoCAD Doors and Windows Block library includes architecture symbols for designing CAD drawings for interior and exterior elevations. How to use AutoCAD’s . March 2010 Paul Munford 6 Comments AutoCAD Tutorials 7.714 FANS 1.034 4.136 134 2.410 SHARES So – The situation is like this. You spent all day copying and pasting notes. To Hatch or Fill an Object or an Area Click Home tabDraw panelHatch. Find On the Properties panel Hatch Type list, select the type of hatch that you want to use. Robert. B2. 00. 8- 0. PMPlease note that I've moved this thread from the ARX forum. For issue #2, iterate thru the Layouts collection, using the Block property of the Layout object to gain access to the layout's placed objects. AMThank you Robert. B. It worked like a champ. I was hoping I would be able to avoid working through the Auto. AutoCAD 3D Door Tutorial . This tutorial shows step by step how to create a 3D door in AutoCAD. In this 3D door is created along with outside frame and handle. It also shows how to apply material to door & handle. Commands used in this tutorial are: Rectagle, Offset, Explode, Presspull. CAD GUI. One less Issue to deal with. Ed Jobe. 20. 08- 0. PMWhat do you mean, ? The layouts collection should be available in odbx. Robert. B2. 00. 8- 0. PMWhat do you mean, ? The layouts collection should be available in odbx. I think that is what they are saying.. It's great to see someone else has discovered o. DBX. I wrote a similar program that reads drawings from a list, prints the title block info along with the issue history, looks for certain errors, creates an Excel matrix of every issue and which drawings were in each, then makes a Word doc drawing list to insert into the project specs. The program has the ability to search Text, MText, Block Attributes, Multileader Text, Table Cell Text, Dimension Override Text and all of these items within Block Definitions. The user may replace multiple search strings, and load & save lists of search strings.What needs to be mentioned about o. DBX is its speed. The above task, which can take DAYS to do by hand, on a project with 1. Yes, 5. 0 seconds! Ed Jobe. 20. 08- 0. PMWow. It's great to see someone else has discovered o. DBX. There's been lots of conversations in here on odbx. I've even written a cls to address some of it's limitations. PMCan somebody help to itrate between the layout collection. Robert. B2. 00. 8- 1. PMCan somebody help to itrate between the layout collection. Surely you know how to create a For Each .. Next loop? sujit. AMSorry about the delay in reply; Rob I could loop through the layouts successfully however when I use the Set attributes function nothing changes. I looked into the code and its because of the row count for the dwg name and the rowcount for the attribs are different any ideas to work around. I hope you understand what I mean. If you want I can attach the modified excel spreadsheetsujit. AMI have to thank Katrina for the spreadsheet it helped me to discover the power of Object. DBX . Robert. B2. PMSorry about the delay in reply; Rob I could loop through the layouts successfully however when I use the Set attributes function nothing changes. I looked into the code and its because of the row count for the dwg name and the rowcount for the attribs are different any ideas to work around. I hope you understand what I mean. If you want I can attach the modified excel spreadsheet. I don't think posting the spreadsheet will help. You need to post your code. Please use the code tags in the advanced editor (the # button). PMI know this thread is several months old. Blocks starting with an asterisk are called anonymous blocks. Layout blocks store the entities in the layout. You access them using the Layout object's Block property. The block items can be accessed using it's Items collection. PMOk think that I understand what you're saying.. You need to search paperspace for Acad. Block. Ref objects, the block insertions. PMWow.. I'll try a search and see what I come up with.. I'll post back if I find something.. I think I'm getting a little closer.. It has an Item method you use to access ents. Try this, put your cursor on the Block method of the layout object and hit F1. Then find the item method, and look at its code example. PMI'm not doing VBA.. I'm in Visual Studio.. It's making a collection of the objects, and then getting out layer . I really am trying to understand it though. Am I even heading down the right path for what I'm trying to do?? Anyway, you can find the help on the Active. X object model in acad. Here's the code sample. Sub Example. I've finally made some progress.. When I use the code below.. Search this forum for . Also, your Start. Autocad sub has an error. The err section should be a call to Create. Object, not Get. Object. PMOk.. I'll see what I can find searching for those. I changed that to Create. Object, I don't think that's causing my problem since I've been running this with Auto. CAD aready open, so it's not going into that section of code.. This issue occurs if you have multiple Paperspace tabs with the specified block inserted in each tab. QUESTIONS: Has anyone out there been able to resolve Issue #2 using Object. Dbx? or. Will I need to go through the Auto. CAD interface and generate selection sets somehow? ATTACHMENT: I attached my Excel file to this posting for reference. It is a very useful tool given the above issues. I am sure that it could have been a little cleaner but at least I have some commenting. Feel free to post questions or comments regarding the program and I will do my best to answer them. Notes: - In Excel VBA, need to reference: Microsoft Scripting Runtime, Auto. CAD 2. 00. 8 type Library, Auto. CAD/Object. Dbx Common 1. Type Library- Compatibility: Auto. CAD 2. 00. 8, Excel 2. Hi, I use this tool a lot and it's very effecient but recently I upgraded to Auto. CAD2. 01. 0 and its now not working. Do you have a version of this tool to work on Auto. CAD 2. 01. 0 or any idea on how to tweak it to work on the 2. Check the project's references for missing type libraries (Tools> References). AMI did these from the reference: uncheck - MISSING: Auto. CAD 2. 00. 8 type Librarycheck - Auto. CAD 2. 01. 0 type Librarycheck - Auto. CAD/Object. DBX Common 1. Librarybut still doest work, error . Shouldnt it be using the from the this file 'axdb. Auto. CAD 2. 01. 0 root folder? Honestly, idnno anything about vba but just guessing. Many Thankscolin. PMHi cftorres,I had the same issue and I have since altered the VBA code so that it now works okay on Auto. CAD 2. 01. 0 using axdb. Object. DBX Common 1. Library). Please let me know if this has sorted out your issue. I also had an issue with Excel truncating leading zeros off attribute text that were in the blocks that I was referencing. The code is now modified so that it changes the format of the cell to text immediately prior to inserting the attribute text. Best Regards,Colinroby. PMHi. Just found this thread and tried the excel on autocad 2. The program opens and runs on Excel 2. Uncheck that an find the version that ships with your version of acad. The name will be similar but end with a different number. PMThanks for the help. I set both autocad 2. Office Excel 2. 01. Autocad/Object. DBX Common 1. Library)It is actually list at first as . After picking it changes its name to . I actually was trying to figure out why my utility wasn't working, did a search on Google, and got sent back to my original post.. Anyways, here is what fixed the problem with me. I downloaded the Autocad 2. Object Enabler package from Autodesk (since they are . I am uploading the file again since I have made some tweaks here and there. That darn hourglass glitch is hopefully gone now. Sorry for the sloppy coding. That is what you get when an engineer programs. I am sure that I will eventually have to put the time in and convert over to . After Autocad 2. 01. VBA support is probably going away.. Also note, the utility will take up less space and work better in newer versions of office if you save it as a . Migth be the places to start from. I sure miss VBdesign web site with the LLama, back in the day I learned a lot there. I will help you test this some more if I can, but it is late here. Robyettore. I'm not a macro expert : (Ed Jobe. PMTake a look at post 3. Auto. CAD is in the 1. MB of RAM range; climbing and dropping about 3. MB for every file . You need to explicitly set them to Nothing in the reverse order that they were created. If you don't you will end up with multiple instances of xl running. You can look at the Processes tab of Task Manager to see how many instances of xl are running. MTEXT editor when MTEXT is edited, object enablers, materials.. Did you solved it? Powered by v. Bulletin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2017
Categories |