10-26-2020
01:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
10-26-2020
01:37 PM
Thanks Yan
I've already tried
Set oWorkbook = oExcel.WorkBooks.adddoes not work
Set oWorkbook = oExcel.Workbooks.Add(Template:="c:\Temp\xy_Template.xls")does not work too and show error on next command
Dim oWorkSheet As WorkSheet
Set oWorkSheet = oWorkbook.Sheets.Item(1)I don't know where I'm making a mistake, but that's how it worked for me for years and still works with excel 2007 but does not work with excel 2016+Inventor 2021
If I run Excel manually before running the macro
that's how it works ???
Sorry about my English
Thanks