5 Replies Latest reply on Sep 19, 2017 8:18 PM by Lee CS Young

    Copy data from Excel File to Embedded SolidWorks Design Table

    Stefan Costanzo

      Hi Guys,

       

      Would anyone be able to tell me if it is possible to copy data from one cell in a workbook to an embedded design table via VBA API. I am having issues as the ".PasteSpecial" command requires a specific file location and name of the excel file it is being pasted into and as far as I know, there is no specific path or filename for design tables, so I cant use this method. Unless anyone knows how to access the location and name, is there another command or method of achieving this?

       

      Set y = Workbooks.Open(" path to destination book ")


      y
      .Sheets("sheetname").Range("A1").PasteSpecial

       

      TIA

       

      Deepak Gupta