+ Reply to Thread
Results 1 to 2 of 2

Writing a simple fill in program

  1. #1
    Registered User
    Join Date
    05-24-2007
    Posts
    1

    Writing a simple fill in program

    Here at the office we name drawing files based on the type of machine they are associated with. Since we have an extensive list of these machines we have a system for abbreviating these machine names before naming a .dwg file.

    This system is in an excel document and right now my people have 6 categories to choose from, each one separated by a dash. The categories are as follows with some examples:

    Product (Turret or Press Brake)
    Manufacturer (Amada or Wiedeman)
    Model (Coma or Pega)
    Old Control (6M or W2)
    Customer Name (PC Controls)
    Drawing Type (Electrical, Mechanical or Panel)

    Alrite, so a dwg file could be named T-Am-6M-PC Controls-Elec.dwg

    Basically what I want to do is write something that would allow them to simply fill in the information and excel would output the correct abbreviation, ensuring that they all use the same abbreviations for every drawing.

    Something that would just ask the Product, Manufacturer ect and output the name string they should use such as T-Am-6M-PC Controls-Elec.dwg (Turret-Amada-6m-PC Controls-Electrical)

    Can someone point me in the right direction, where I could learn how to write this myself? Any help would be greatly appreciated.
    Last edited by jackleman; 05-24-2007 at 03:51 PM.

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,204
    If you have some experience with Excel, I'd point you at the Forms Menu, specificaly Check Boxes and Combo Boxes. The help system should lead you through making 6 controls that will make your abreviation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1