Peoplesoft/b

Advertisement


Question
Sir,
I have a project in my company where we need to automate the packaging process.
It goes like this:
Description: Material arrive at docking area. They are checked for packaging. and if packaging found not as per standard they are rejected.
Problem: As material arrives at a very fast rate there is a need to automate thew process
Work Done so Far: Till now I am able to make a macro code in Excel wherein if an item number is pasted into a specific cell it searches for pdf attached to that number and automatically displays that pdf. That pdf contains the information regarding packaging standard
Requirements: 1.) Now to execute this automatically I want a scanner that can scan a 2-D bar code which contains all information like item number, Quantities, Vendor code etc., extracts only item number and paste that item number into that specific cell of Excel.Please note I want Excel to paste the data and not as if it is typing into that cell.Is it possible?
2.) It should be wireless as we have huge area to cater to

Also I already have Honeywell's Voyager 1202g(Wireless) and Psion Teklogic 7535 Handheld in my company. Please tell me if it is possible to do these things with any of this scanner.
Thankyou in Advance

Regards
Saurabh Mundeja

Answer
Hi,

Sincere apologies for late reply.

You can automate your requirements using custom approach.

http://www.idautomation.com/kb/excel_macro_addin.html

check the above for automating Excel for bar code reader. The same link has many resources for your kind of need.

Thanks
MS

Peoplesoft

All Answers


Answers by Expert:


Ask Experts

Volunteer


Mahendra Singh

Expertise

I will answer questions related to PeopleTools, Installations, configurations and upgrade issues for versions from 7.5 to 8.4x.

I can answer questions in HRMS Modules as well:

Core HRMS

Time and Labor

Absence Management

Payroll Interface

Global Payroll

North American Payroll

UK Payroll

===================================

Experience

I am working in Peoplesoft Technical Consulting since 2000.

Education/Credentials
MCA, MBA and various other certifications. I am ITIL certified as well.

©2016 About.com. All rights reserved.