+ Reply to Thread
Results 1 to 3 of 3

dificulty with AutoSave due to constant inbound Keystrokes

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    new hampshire
    MS-Off Ver
    Excel 2010
    Posts
    37

    dificulty with AutoSave due to constant inbound Keystrokes

    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.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: dificulty with AutoSave due to constant inbound Keystrokes

    One of the optimisation codes might help you there.

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    new hampshire
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: dificulty with AutoSave due to constant inbound Keystrokes

    DisplayStatusBar did the trick. Thank you kindly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-11-2015, 04:26 AM
  2. [SOLVED] Prompt for KeyStrokes
    By publius190 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2014, 11:54 AM
  3. Disable <+> and <`> keystrokes
    By bagulhodoido in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2011, 09:51 PM
  4. Dificulty finding the right combination for a complex lookup.
    By jamesyoung79 in forum Excel General
    Replies: 4
    Last Post: 05-20-2009, 07:31 PM
  5. Trap Keystrokes
    By Steel Monkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2007, 08:13 PM
  6. VBA to disable keystrokes?
    By Mark in forum Excel General
    Replies: 3
    Last Post: 05-24-2006, 10:55 AM
  7. Opened Autosave but when closing workbook Autosave closes itself
    By Ken in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1