+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Super Member stevsmith's Avatar
    Computer Details
    stevsmith's Computer Details
    Operating System:
    Windows 7 (64bit)
    Computer:
    Dell Precision T3500
    CPU:
    Intel Xeon W3670 (Six Core 3.2GHz, 12MB Cache)
    RAM:
    12 Gb Ram (3x4GB) DDR3
    Graphics:
    2GB NviDia Quadro 4000
    Monitor:
    Dual screen - BenQ G2020HD 21"
    Discipline
    Mechanical
    stevsmith's Discipline Details
    Occupation
    High Plains Drifter
    Discipline
    Mechanical
    Using
    not applicable
    Join Date
    Apr 2008
    Location
    Largs, Scotland
    Posts
    980

    Default Link an ECN Number in a Rev table to EPDM (Solidworks)

    I'll keep this simple for now.

    We would like to enter a revision table into a drawing, then enter an ECN number within that table that has a hyperlink to a spreadsheet located in our EPDM.

    Is it possible.
    Steven Smith
    Solidworks - CSWP | AutoCad


  2. #2
    Forum Deity shift1313's Avatar
    Using
    not applicable
    Join Date
    Sep 2008
    Location
    VA
    Posts
    2,859

    Default

    When you are inserting a table in a drawing you have the option to insert an Excel based table. It sounds like you might want to format your excel file to be the table. You can link your global variables/equations to an external file.

    How is the spreadsheet populated?
    Matt - Certified Solidworks Expert -Advanced Surfacing, Mold Tool and Sheet Metal Specialist
    Current Software: SolidWorks11,SolidCam11
    http://www.solidworkslessons.info/
    www.mysolidbox.com

  3. #3
    Super Member stevsmith's Avatar
    Computer Details
    stevsmith's Computer Details
    Operating System:
    Windows 7 (64bit)
    Computer:
    Dell Precision T3500
    CPU:
    Intel Xeon W3670 (Six Core 3.2GHz, 12MB Cache)
    RAM:
    12 Gb Ram (3x4GB) DDR3
    Graphics:
    2GB NviDia Quadro 4000
    Monitor:
    Dual screen - BenQ G2020HD 21"
    Discipline
    Mechanical
    stevsmith's Discipline Details
    Occupation
    High Plains Drifter
    Discipline
    Mechanical
    Using
    not applicable
    Join Date
    Apr 2008
    Location
    Largs, Scotland
    Posts
    980

    Default

    I'm not looking to populate the rev table from a spread sheet Matt, more so just to provide a link to it.

    Basically the revision table in the drawing will contain a brief description of the change and the hyperlink will open the excel/word file to allow the user to see a more in-depth explanation of the changes made to the drawing.
    Steven Smith
    Solidworks - CSWP | AutoCad


  4. #4
    Forum Deity shift1313's Avatar
    Using
    not applicable
    Join Date
    Sep 2008
    Location
    VA
    Posts
    2,859

    Default

    that shouldnt be a problem. You can make a hyperlink to a text box. When add a "note" under the annotation tab in the properties under "Text Format" there are a few options for linking. The first icon with a globe and chain link will allow you to add a hyperlink. From there you can either enter a www. or browse to a file location. Im honestly not sure how this will work with PDM since you have to log in. Spreadsheets I don't believe need to be "checked out" so it should work fine.

    Let me know if you have trouble finding the hyperlink format area and ill snap some screen shots.
    Matt - Certified Solidworks Expert -Advanced Surfacing, Mold Tool and Sheet Metal Specialist
    Current Software: SolidWorks11,SolidCam11
    http://www.solidworkslessons.info/
    www.mysolidbox.com

  5. #5
    Super Member stevsmith's Avatar
    Computer Details
    stevsmith's Computer Details
    Operating System:
    Windows 7 (64bit)
    Computer:
    Dell Precision T3500
    CPU:
    Intel Xeon W3670 (Six Core 3.2GHz, 12MB Cache)
    RAM:
    12 Gb Ram (3x4GB) DDR3
    Graphics:
    2GB NviDia Quadro 4000
    Monitor:
    Dual screen - BenQ G2020HD 21"
    Discipline
    Mechanical
    stevsmith's Discipline Details
    Occupation
    High Plains Drifter
    Discipline
    Mechanical
    Using
    not applicable
    Join Date
    Apr 2008
    Location
    Largs, Scotland
    Posts
    980

    Default

    Registered forum members do not see this ad.

    I found it today Matt. Cheers mate.
    Steven Smith
    Solidworks - CSWP | AutoCad


Similar Threads

  1. Replies: 3
    Last Post: 13th Feb 2012, 06:09 pm
  2. Link Table to Attributes
    By Guiboard in forum AutoCAD Beginners' Area
    Replies: 4
    Last Post: 16th Feb 2011, 03:08 pm
  3. Link table data Via field
    By Guiboard in forum AutoCAD General
    Replies: 2
    Last Post: 1st Nov 2010, 02:28 pm
  4. Excel Table Data Link
    By johnv in forum AutoCAD General
    Replies: 17
    Last Post: 31st Jul 2009, 12:11 am
  5. Edit Table with Data Link
    By Tconn in forum AutoCAD General
    Replies: 4
    Last Post: 25th Sep 2008, 02:20 pm

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