- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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