rozbaz
02-20-2014, 03:34 AM
Hello vba gurus:)
I would like to know if the scenario below is possible.
Today through the use of a barcode scanner i do scan barcodes in an excel in A2 and in C2 i have a vlookup formula (actually an index-match formula because the vlookup is reversal) that results to an SKU code that i have in Sheet2. Upon that I copy and alt-tab to the ERP of the company and then i paste.
I would like to make this scenario automatic through some kind of background vlookup so i dont have to alt+tab.
So that these barcodes that gets scanned i would like the scanner to type the result of the vlookup instead of what it actually scans.
The way i have imagined this concept is that if something gets typed while another key is pressed (e.g. ctrl) then this will initiate a vlookup and the actual typing would get overwritten by the vlookup result. Maybe a software like AutoHotkey would be necessary but i am not sure.
That all should be done in background because i want this to get typed in an ERP system and not in excel.
Hope this is possible
Thank you in advance
I would like to know if the scenario below is possible.
Today through the use of a barcode scanner i do scan barcodes in an excel in A2 and in C2 i have a vlookup formula (actually an index-match formula because the vlookup is reversal) that results to an SKU code that i have in Sheet2. Upon that I copy and alt-tab to the ERP of the company and then i paste.
I would like to make this scenario automatic through some kind of background vlookup so i dont have to alt+tab.
So that these barcodes that gets scanned i would like the scanner to type the result of the vlookup instead of what it actually scans.
The way i have imagined this concept is that if something gets typed while another key is pressed (e.g. ctrl) then this will initiate a vlookup and the actual typing would get overwritten by the vlookup result. Maybe a software like AutoHotkey would be necessary but i am not sure.
That all should be done in background because i want this to get typed in an ERP system and not in excel.
Hope this is possible
Thank you in advance