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

​