Or, move away from trying to use Excel as a database, which it isn't.
In a database it is "duck soup" to find duplicates (which is ok), or prevent them (which is probably better). Moreover, databases are made to be used by several users, and it's easy to set up various levels of...
The sheet metal program could work for unfolding the sheet into flats. However, the sheet metal program would not prevent you from designing structures which would not inflate to the shape you designed.
If you are an experienced inflatable designer, I am sorry for belaboring the obvious, but...
I have written a fair amount of AutoLISP (a long time ago, admittedly) and VBA. My first choice would be VBA.
VBA skills are transferrable to a lot of other apps, but AutoLISP is only useful in AutoCAD. The IDE's for Visual Basic are very similar from MS Excel to MS Access to MS-whatever, and...
I never responded because I didn't know any easier way than the HNGRR method.
Gad! No offense intended, HNGRR, but what a mess. Just another example of Microsoft's ambivalence toward Access. It competes with SQL Server, so it is a Red-Headed Stepchild in Redmond.
Why can't you click one...
There are commercial indexers available for AutoCAD, but I don't know about .pdf"s. Do you produce the pdf's?
AFA ACAD -- if you want to do "homebrew," how about saving as DXF? Or adding a layer with your indexing info and leaving it "off?"
Or, ignoring AutoDesk's...
For those that are still with us, or who get here via the Keyword Search feature: There is a FREE utility for putting Excel data into ACAD drawing entities. I found it in thread770-43557, and it works very well for a FREE utility. It's FREE, too.
Ron
OK, if anyone is still with us, here; I found LivelinkII at http://www.vbdesign.net/cadencoding/files/LiveLink.zip It's available as a link from http://www.cadencoding.com/modules.php?name=News&file=article&sid=12
It works. Not perfect, and not perfectly intuitive, but it works, and it is free...
In addition to "hiding" formulas, one other "security" issue arises with Excel.
If you keep a spreadsheet under your own control, then it is just a programmable calculator.
If everyone has their own copy of the spreadsheet or access to the original (shudder,) you are...
OK, the simplest way I was able to find:
Record a macro of running a query on your database. "Tools";"Macro";"Record New Macro"
Not really important what query you run, it's just to get the wizard to do the heavy lifting of writing the code to connect to a db, run...
This might get a quicker response on Tek-Tips, this site's sister. It's more IS oriented.
Let me make sure I understand the question -- you want to make a parameter query based on parameters entered into a cell or cells in the spreadsheet, and then return the results to another page on the...
Crystal Reports is much more flexible in its handling of variable-length data. In fact, it's more flexible, period.
But, short of buying new software, I agree with Dave Viking -- export to Excel and do it there. Ditto with charts and graphs; Access charting is just not as smooth as Excel.
You...
There are some commercial products and some freeware products that translate Excel spreadsheets to AutoCAD editable tables. Look on some of the CAD-related sites, or maybe tucows.
Ron
