title: Excel - how to have Multiple Input Devices (USB)
body: <p>How do I differentiate between 2 USB input devices that are both placing data into the spreadsheet?</p>
  
  <p>I have 2 USB calipers that input their current measurements as if they were keystrokes. The data is sent to excel (or any program really) and placed vertically. Currently, Excel treats both calipers as if they were the same instrument.</p>
  
  <p>What I would like to have is the two calipers record their data into distinct areas of the excel spreadsheet. </p>
  
  <p>An example would be Tool 1 and Tool 2 are both being used simultaneously by two different people while both connected to the same computer. Tool 1 will always put its data in the following areas: (A1,B1,C1, A2,B2,C2 ... etc.)  Tool 2 will record its data into the following areas: (A5,B5,C5, A6,B6,C6 ... etc.)  The data does not have to go into the same sheet, it can be in different sheets or whatever is easiest.</p>
  
  <p>Can anyone help?</p>
  
  <hr>
  
  <p><sup><b>updated to include content originally provided as an <i>answer</i></b></sup><br><br>
  A few questions:</p>
  
  <p>1) Where can I find the information for the "Scripting.FileSystemObject"?  I assume this line needs to be replaced with an identifier for each of the individual usb tools. In device manager they are listed as HID Keyboards but I see no identifying number. </p>
  
  <p>2) Do I just copy-paste the above three sets of code into the VBA under Sheet1 for USB1 and Sheet2 for USB2, or do they need to be placed in individual macros?</p>