Hi
I am in the process of migrating users from Access 2010 to Access 2016
I know that Excel 2016 creates a separate instance of Excel for each individual workbook but after.....
....when I make Excel and the output visible, there is always an empty "ghost" window which is allegedly part of the original export - check out the timestamp in the snip below.
The same thing happens whether it is a XLS or XLSX specification
Closing the "ghost" closes the "real" window
When I used the immediate window in Excel to ask how many windows are open.....
.....I am told there is only one window
Anyone know how to use VBA to get rid of the superfluous window to avoid user confusion as well as my own ?
I am in the process of migrating users from Access 2010 to Access 2016
I know that Excel 2016 creates a separate instance of Excel for each individual workbook but after.....
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "_Debug", ExportFileName
The same thing happens whether it is a XLS or XLSX specification
Closing the "ghost" closes the "real" window
When I used the immediate window in Excel to ask how many windows are open.....
Code:
? activeworkbook.Windows.Count
1
? activeworkbook.Application.Windows.Count
1
Anyone know how to use VBA to get rid of the superfluous window to avoid user confusion as well as my own ?