Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

@bradeneuropeArthur ,

 

Thank you for the response. That is fascinating. I referenced the addin with an object per your comment and now I get no error.

 

There seems to be some changes to how VBA operates in this version. For example, I have public variables I use for Excel declared with this: Public oExcel As Object, oWorkbook As Excel.Workbook. I could create Excel applications and workbooks with no problems in INV2019 and INV2022. I then updated to INV2022.1.1, and my code kept failing on this line: Set oWorkbook = oExcel.Workbooks.Add. Nothing had changed with my references, I only updated inventor. The way I got it to work again was changing how I declared the workbook object: oWorkbook As Object. How can something like this be affected by an INV update?

 

Thanks again for the help.

 

Regards,

Rafael