Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by paron

  1. paron

    Extracting data from excell

    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...
  2. paron

    alternative to .EXE files

    You could consider putting the file (zipped for download time) on a server and just sending a link.
  3. paron

    Cad for Fabric Structure design.

    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...
  4. paron

    Programming Help, anyone?

    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...
  5. paron

    Exporting MSAccess reports gives poor results, suggestions?

    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...
  6. paron

    MS Office document properties / FileSearch / pdf / dwg

    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...
  7. paron

    INSERT TEXT INTO DWG

    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
  8. paron

    Pasting Excel into AutoCad

    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...
  9. paron

    Pasting Excel into AutoCad

    I went there, can't find the download. Can you post a link to a specific page at the site? I went to (site)>downloads>excel.
  10. paron

    why should we use excel

    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...
  11. paron

    Microsoft Query in Excel

    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...
  12. paron

    Microsoft Query in Excel

    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...
  13. paron

    Microsoft Access Reports Question

    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...
  14. paron

    CAD Files of Components & Damper (Shock) Data

    How about a Yahoo or Hotmail group? Or, just post to the IHPVA website? Ron
  15. paron

    .xls to AUTOCad 2002 problems

    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
See more

Part and Inventory Search

Back
Top