+ Reply to Thread
Results 1 to 3 of 3

a code to know from where the input came?

  1. #1
    Registered User
    Join Date
    12-02-2018
    Location
    Jordan
    MS-Off Ver
    2016
    Posts
    2

    Question a code to know from where the input came?

    So I have a computer that I've connected multiple balances on it, each balance on a COM, and each time I print the weight on the balance it appears on excel as a value only, but now I want to add a code to verify from where each reading came from.



    I use the macro code to add Time&Date stamp for each reading, but now I need to verify the source, maybe using an if the command that if the reading came from COM3 for example excel will write Balance 1

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: a code to know from where the input came?

    What's your interface for getting the readings from the COM ports into Excel?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-02-2018
    Location
    Jordan
    MS-Off Ver
    2016
    Posts
    2

    Re: a code to know from where the input came?

    Hmmmm
    I use USB B to A cable to connect the balance to the PC, inside device manager is shown as USB interface device under Human interface devices

+ 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. Code working only for a standard input. If input changes then code behaves differently
    By DhanyaTeacher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2018, 12:41 AM
  2. [help with code] need to update existing code to copy and keep rows on input page
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2016, 01:36 PM
  3. [SOLVED] Need input box in working code
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2014, 08:45 AM
  4. [SOLVED] Input code on one page --> correct input on the other
    By jacksoss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2012, 01:25 AM
  5. Changing code from Manual input to Calculated input
    By Gertheking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2012, 11:41 AM
  6. Code help appreciated:following code to restrict character input
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2006, 12:20 AM
  7. Replies: 1
    Last Post: 09-29-2005, 08:05 AM

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