Macro to enter data into a windows desktop application

Search more jobs
Posted
Worldwide

Enter Part Number and hit tab.  After part number is displayed, click on Edit / Place workorder and from the child window, enter Warehouse Id, then four tabs to skip over four unused fields, then enter Release Date, Want Date, Order Qty and then check Released and click on Order.

Repeat the operation for the rest of the items in the spreadsheet

The spreadsheet format is attached

Update the Success = Y or N, depending on if the macro was successful in entering the data.
If the macro was not successful, write in a log file why it was not successful.

The first video shows successful data entry
The second video shows what all error can be expected

When an error is encountered, mark Success = N and enter the reason in the log file

Possible Errors that could happen (see second video)
1. Bad Part Number
2. Missing Engineering ID


If the program cannot detect the completion of Order, then there has to be a wait-seconds value in the config file that can be adjusted, so that the macro waits for those seconds before attempting to enter the next part number.  Ideally, the program should be able to detect the completion of the Order entry.

The program should be small and ideally should run as a standalone executable without the need to install it on the computer


Thanks
  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Intermediate
    Experience Level
  • $10.00-$25.00
    Hourly
  • Remote Job
  • One-time project
    Project Type

Skills and Expertise

Desktop Application

Activity on this job

  • 10 to 15
    Proposals
    10 to 15
  • 2 days ago
    Last viewed by client
    2 days ago
  • 8
    Interviewing
    8
  • 0
    Invites sent
    0
  • 0
    Unanswered invites
    0

About the client

Member since Mar 18, 2008
  • United States
    Chicago 5:11 pm
  • 232 jobs posted
    40% hire rate, 3 open jobs
  • $13,803 total spent
    97 hires, 17 active
  • $8.22 /hr avg hourly rate paid
    701 hours
  • Member since Mar 18, 2008

Explore similar jobs on Upwork

Python - ArcGIS Pro - ESRI - MAPPING
New
Hourly ‐ Posted 14 minutes ago
ArcGIS GIS Python Geospatial Data Digital Mapping ArcGIS Online GUI Design
Make OpenGL Application Working Properly
New
Fixed-price ‐ Posted 3 hours ago
C++ OpenGL

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
4.9/5
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
49,000+
Signed contract every week
$2.3B
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo

Other open jobs by this Client (1)