Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Humbled_Guy

    I can't create a simple VBA macro to search and find

    Yes you are correct, each requisition is a representation of one patient. If the doctor ordered 3 test to be performed for the patient then 3 test will be ordered (Hospital etc), performed (via the lab) and billed (via my department, the billing dept).
  2. Humbled_Guy

    I can't create a simple VBA macro to search and find

    The test are scraped via the initial data input via the lab, after the laboratory work is processed (blood work, urine samples, imaging of reqs, etc) then once the information is imaged, our billing department pulls from various ques to be coded and eventually billed. So each req will populate...
  3. Humbled_Guy

    I can't create a simple VBA macro to search and find

    Correct (image viewer), the Optum box is the input boxe I created and intend to pass the numeric vals (tests) to the emu screen. So after the test is selected, the next ordered test is selected (1<enter>, 4<enter>,etc)and then the req is processed and powerterm pulls the next req to be processed.
  4. Humbled_Guy

    I can't create a simple VBA macro to search and find

    From the emulation screen (powerterm), simply entering a test code (IE 34429)is prohibited, instead you are expected to find the test code on the imaged requisition (2nd screen aka image viewer) and select the corresponding code by selecting the 1-15 number (only options to enter are 1-15). When...
  5. Humbled_Guy

    I can't create a simple VBA macro to search and find

    I don't really need to copy/paste the data since it's already there. I guess what I'm looking for is: 1. a way to enter a numeric value (test code) 2. have it search/compare via on screen data 3. move the cursor position to the corresponding 1-15 "No. selection", 4. left button click to...
  6. Humbled_Guy

    I can't create a simple VBA macro to search and find

    Thank you for your awesome reply Skip! How you were at 40 is exactly how I am at 38 :-) (concerning programming). Skip please have a look at this screenshot of the workflow example. Hopefully this can help you understand better exactly what it is that I'm trying to accomplish. Also if you could...
  7. Humbled_Guy

    I can't create a simple VBA macro to search and find

    Hello and thank you for taking interest in helping me with my problem. First and foremost I am billing coder with aspirations of becoming a programmer one day. This year was the year that I discovered macros, scripts, automation, etc. and I have completely falling in love with it. However I only...

Part and Inventory Search

Back
Top