AnsweredAssumed Answered

Opening another Workbook via Macro in Design Table

Question asked by Andrew Pogue on Feb 22, 2021
Latest reply on Feb 22, 2021 by Josh Brady

I am trying to open an excel workbook from within an excel design table via a macro. The excel workbook is contained within the same folder as the solidworks part file.

Usually this would be easy - "Workbooks.Open Filename:=ThisWorkbook.Path & "\openthis.xls", however as the design table is not external from Solidworks it does not show a file path (it is just blank and would return "\openthis.xls").

Has anyone else had this problem and found a workaround?

 

Thanks,

 

Andrew Pogue

Outcomes