XLS table in drawing

Discussion in 'SolidWorks' started by Ben Eadie, Oct 5, 2005.

  1. Ben Eadie

    Ben Eadie Guest

    Little out of the ordinary, but I have a drawing with several sheets
    that require a paint colour table for the painters to follow so they one
    paint the right colors and two dont paint the inside of the bushings
    on the assembly. Paint by numbers anyone?. I have a *.xls file that I
    would like linked to a general table in the drawing, better yet, on all
    sheets.

    So how do I link a *.xls table to a general table on a drawing. The next
    step would be how do I have it link to all the general tables on all the
    sheets of the drawing, is this as simple as copying the table once the
    link has been established?

    Cheers,
    Ben
     
    Ben Eadie, Oct 5, 2005
    #1
  2. Ben Eadie

    SteveT Guest

    I believe that you will have to embed the actual excel file into the
    sheet -- OLE has an option to link to the original file.
    There is no way to link excel cells back to cells in a general table.

    Hope that helps
    Steve T.
     
    SteveT, Oct 5, 2005
    #2
  3. Ben Eadie

    Ben Eadie Guest

    Ok then next dumb question. I have never embedded a xls file how is it
    done? Really no help in the help on this

    Ben
     
    Ben Eadie, Oct 5, 2005
    #3
  4. Ben Eadie

    Ben Eadie Guest

    Never mind I got it

    Ben


     
    Ben Eadie, Oct 5, 2005
    #4
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.