AnsweredAssumed Answered

Copy data from Excel File to Embedded SolidWorks Design Table

Question asked by Stefan Costanzo on Aug 20, 2017
Latest reply on Sep 19, 2017 by Lee CS Young

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

Outcomes