We are using Bluetooth scanners to input data into an excel sheet on the floor. The sheet was coded to protect each row after data was entered and then save the file. The issue I'm having is that the wifi signal out there isn't always the greatest and incoming scans can be rapid: What is happening is when a scan comes in and the Excel file starts the save sometimes the next scan will come in while the "saving as" dialog box is still up. I'm not talking about the box that prompts you to save the file but the one with the green bar showing the actual saving processes progress. Is there a way to suppress that box? The way it is currently structured If I rapidly scan ten or so barcodes it will end up omitting 2 or 3 of them. The file needs to save constantly so the dashboards linked to it can display live results and the scans coming in can be sporadic. I can't share my sheet due to sensitive info but I'm using a simple change event to start the save process. Any advice would be greatly appreciated.
Bookmarks