I describe the problem with Excel Office 365 compared to Excel 2007. I create an Excel type “xlsm”, Excel with Macros content, in which I have VBA code, we will call it Sheet_Macro The objective of this Excel-Macro is to read an Excel Book of data xls, cxlsx, xlsm , we will call it Sheet_Data , as if it were a DB.
This is done with a driver from Microsoft.Provider=Microsoft.ACE.OLEDB.12.0; Data Source=Data_Sheet;Extended Properties='Excel 12.0 Macro;IMEX=1;HDR=NO
After doing a Select , it is retrieved as if it were a database RecordSet. The problem is that, when I activate the Sheet_Macro, for execute the reading of the Data_Sheet, it opens the Data_Sheet from Office 365, and the Data_Sheet is opened by another user, Excel is activated and the Data_Sheet is displayed.
However, if this same operation is performed from Excel2007, the Data_Sheet is not opened in Excel nor is it displayed .This makes the data opening and processing time much faster (1,000 x 100)