Information on auto saving data using Macro

...Excel should autosave those 3 serial numbers...

What does this mean? To the sheet? To a new file? All on the same row? On different rows?

Hi,
Thanks for the reply. Saving on a Different File would be best, but if it is to be saved to any of the options that you provided, they are fine too. All I want is the Data to be Saved, doesn't matter where and the data shouldn't get lost incase the computer gets restarted unexpectedly or crashed.
All the 3 values along with the Date and Time stamp should be in the same row.

Thanks

See if this is what you're looking for.

I do not know of any published series. Youtube has quite a few. Ozgrid.com has a few.

Sorry, I don't understand.

I forgot to add the mypath to pull it from the D1.

Here's a updated version.

New is probably a misnomer. It should be Clear. It's to clear all the textboxes and start over. But due to the way VBA works, you can't cancel the save if all three bar codes are input. I can change it to where you have to press a command button to save it, if that's a problem. If you Tab out of hte last textbox, it will save it also.

My barcode scanner adds a Enter to all scans. You may be able to set yours up the same way.

Thank you for the update, My barcode scanner also does the same and it saves the data as soon as I scan the 3rd Barcode in the textbox. Thanks a bunch Tinbendr, you rock!!!

Edit: I need one more small change , I see that everytime we open the excel file we need to enable the macros. I changed it to allow all macros in my pc.... but I need to use this on one of my PC's at a different location and I need to use it every day. Is there a way to set the MACRO security settings to "Allow All Macros" in the VBA code , after the first run or something??

Is there a way to set the MACRO security settings to "Allow All Macros" in the VBA code

No. The security is not exposed to the VBA model. Doing so would render the security meaningless. You'll have to change the security settings through the menus.