Excel, Become, excel vba
Project status
Interested
Posted at
Location
Budget
Posted by
Dear freelancer,
I work for a company that specializes in the study, commissioning and maintenance of fire detection systems. We work with external installers who install our systems.
All our products have a unique product number (PN), via a sticker on each product, and are placed in loops. In the final phase of a site, we go on site and can 'scan' the installed loops using software from our supplier. Each loop scan is a Word document.
In the study phase of a project, a list is drawn up of all components that will be installed. In Excel we keep all information per point (number, type, point name, detection zone, control, plan, ...) and a PN column. We provide this list to the installer, who will then paste the barcode next to the correct number for each element he installs. We then enter the barcodes in our list with a barcode scanner.
What we do now: we open each loop scan in Word, save it as txt, open it in Excel, and use a VB code to search for each PN number of the elements of the scans in Excel. The loop number and location on the loop are then entered, so that all information is synchronized.
We wonder whether it is possible to automate this entire step-by-step plan using some code/software: that the list is automatically supplemented per loop scan that is placed in a certain folder, or via a few clicks, ...
We are curious about the possible proposals.
If interested, I can provide some screenshots upon request to describe the above more clearly. Possible extensions of this question are possible.
Thank you in advance.
Do you know a someone who is a good fit for the project? Earn commission by referring professionals! For every signup you get € 5 directly in your account and when the professional is hired through the platform you earn 2 % of the earnings of this professional!
Fill in the details of the pro you'd like to recommend:
When the professional accepts the invitation this professional will automatically be added to your network and you'll earn 2 % over all earnings by this professional through the platform. For more information see our Terms and conditions
{{ item.displayDisciplines }}
No interested professionals yet
{{item.displayDisciplines}}
You have a stand-by account and already responded to 1 project in this subscription period.
Upgrade your account now with just 1 click and respond to unlimited projects.