Need help on macros in visual basic, Visual Basic Programming

Assignment Help:

I have an excel list with a lot's of serial numbers that have been entered by hand from PDFs online (1-5 serial numbers per PDF). Many of the values are duplicates, wrong, or contain superfluous characters. There are 397 rows presently (about 350 PDFs), and I would like them cleaned up and corrected.

From my limited knowledge of Visual Basic, I think some of this will be cleaned using macros, but much of it will have to be done by hand. You need to be elegant, because there is some investigatory work that needs to be done and you need to figure out what fits and what doesn't. A fast internet connection is recommended as some of the PDFs are fairly large.

Desired Skills

Microsoft Excel, Visual Basic, English


Related Discussions:- Need help on macros in visual basic

Message routing - visual basic, Message Routing: The system posts the ...

Message Routing: The system posts the messages to a first-in, first-out queue known as the message queue or it sends the messages directly to a window procedure. The Messages

Hotel management system, i need to do my final project for my last year bsc...

i need to do my final project for my last year bsc honours degree in Business Information systems. I need to develop a system which is operational for hotel management system. th

Program for elevator application, You are given a console program in both V...

You are given a console program in both VB and C# that uses a class CElevator (ElevatorAppAssign). The main modules are in the assign directory class files. Below is a discus

Create vb to play a variation of hangman, Goal Create a Visual Basic th...

Goal Create a Visual Basic that allows a user to play a variation of Hangman. User Inputs • The user types a letter into the textbox. Functional Items 1. Read a series

Steps for creating a multiple document interface (mdi) form, Steps for Crea...

Steps for Creating A MDI Form: 1. Build a new form and set IsMdiContainer property to true. 2. Build a child form class to add to the form. 3. Now Right click the proj

Create a visual basic application to play Hangman game, Create a Visual Bas...

Create a Visual Basic that allows a user to play a variation of Hangman. User Inputs The user types a letter into the textbox.   Functional Items 1. Read a

Write a program to sort and display an array, Problem 1. Describe the i...

Problem 1. Describe the importance and usage of .net framework in visual Studio 2. Write a program to sort and display an array of integers in ascending order using the conc

Displaying a file with scrolling - document class, Displaying a file With S...

Displaying a file With Scrolling: To display a file with the scrolling option allows the steps as shown below: 1. Generate a SDI application. 2. In the Step 6 of the App

Multiple Forms Issue, i want to use two forms in vb.net. when the progress ...

i want to use two forms in vb.net. when the progress bar in form1 reaches on a specific value then disable form1 and progress bar will stop and the second Form2 will popup which wi

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd