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
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- 10 to 15Proposals
This range includes relevant proposals, but does not include proposals that are withdrawn, declined, or archived. Please note that all proposals are accessible to clients on their applicants page.10 to 15
- 2 days agoLast viewed by client
This is when the client last reviewed or interacted with the applicants for this job.2 days ago
- 0Invites sent0
- 0Unanswered invites0
About the clientMember since Mar 18, 2008
- United States Chicago 5:11 pm
232 jobs posted
40% hire rate, 3 open jobs
total spent 97 hires, 17 active
avg hourly rate paid
- Member since Mar 18, 2008
Explore similar jobs on Upwork
How it works
Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
From contract to payment, we help you work safely and get paid securely.
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.