maxis
11-10-2017, 10:12 AM
Our Access Database (2003 format) opens and closes an Excel spreadsheet (.xlsm) up to 100 times to do inter-related calculations. Designed many years ago, Access opens the spreadsheet, the spreadsheet does the calculation, then Access closes the spreadsheet and keeps the results. It does it over and over again until the amounts come within a certain threshold. That's the nature of the inter-related calculations (over my head).
For our users running Office 2010 it works just fine. But we recently started upgrading to Office 365 (2016) and this same process causes the screen to flash because you can actually see the spreadsheet opening and closing, as well as Windows displaying the EXCEL icon on the Windows Task Bar. The calculations all work, but with Office 365 all these behind the scene opening and closing of the spreadsheets that went unnoticed in Office 2010 make the screen "flash" because it appears that it simply doesn't run as well in Office 2016 with regards to doing all these behind the scenes opens/closes.
Our question is whether or not there is something in Access vba that could turn off the "showing Excel icon on the task bar" and/or "the opening and closing of the spreadsheet". The only analogy is like the ECHO OFF in DOS. Commands are being executed BUT NOT DISPLAYED to the user. Is there something similar in ACCESS vba that would "not display" or "turn off" these extra steps that Access/Excel are doing assuming the spreadsheet is being open for User input instead of behind the scene calculations? Kind of like "working in invisible mode" while you're doing all those behind the scene opens/closes - we never really have to see the spreadsheet that's being opened/closed.
Thank you.
For our users running Office 2010 it works just fine. But we recently started upgrading to Office 365 (2016) and this same process causes the screen to flash because you can actually see the spreadsheet opening and closing, as well as Windows displaying the EXCEL icon on the Windows Task Bar. The calculations all work, but with Office 365 all these behind the scene opening and closing of the spreadsheets that went unnoticed in Office 2010 make the screen "flash" because it appears that it simply doesn't run as well in Office 2016 with regards to doing all these behind the scenes opens/closes.
Our question is whether or not there is something in Access vba that could turn off the "showing Excel icon on the task bar" and/or "the opening and closing of the spreadsheet". The only analogy is like the ECHO OFF in DOS. Commands are being executed BUT NOT DISPLAYED to the user. Is there something similar in ACCESS vba that would "not display" or "turn off" these extra steps that Access/Excel are doing assuming the spreadsheet is being open for User input instead of behind the scene calculations? Kind of like "working in invisible mode" while you're doing all those behind the scene opens/closes - we never really have to see the spreadsheet that's being opened/closed.
Thank you.