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

Displaying the database - data control, Displaying The Database: The T...

Displaying The Database: The Text box, image box, check box, labels, picture box can be bounded to the data control for exhibiting the data base contents. The two properties a

Variant subtypes, Beyond the simple string or numeric classifications, Vari...

Beyond the simple string or numeric classifications, Variant can make added distinctions regarding the specific nature of numeric information. For instance, you can have numeric in

Account Balance, The user has to enter a starting balance, the dollar amoun...

The user has to enter a starting balance, the dollar amount of deposits, and the dollar amount of withdrawals. the program then has to calculate the balance

Windows 32 bit (win 32) applications, WINDOWS 32 BIT (WIN 32) APPLICATIONS ...

WINDOWS 32 BIT (WIN 32) APPLICATIONS   The Win 32 based applications are the applications developed for the windows family of the operating systems. The Win 32 applications ac

Menus and tool bars in visual basic, MENUS AND TOOL BARS   The Menu op...

MENUS AND TOOL BARS   The Menu options can be checked, enabled, disabled, and popped up on an object. The Menu Object: The Menu control is used to generate a menu in

Introduction to controls and toolbars, INTRODUCTION TO CONTROLS AND TOOLBAR...

INTRODUCTION TO CONTROLS AND TOOLBARS The Visual Basic programming is an event driven programming. In the form objects the termed controls are placed. We can put the properties

Balancesheet, i need sample balance sheet form in vb.net

i need sample balance sheet form in vb.net

Ddx - dialog data exchange, DDX - Dialog Data Exchange: The Data membe...

DDX - Dialog Data Exchange: The Data members can be related with specific controls in the dialog box. When the dialog box is displayed, the DDX will transfer the values into t

Application for vehicle dealership, A vehicle dealership has a number of di...

A vehicle dealership has a number of different items for sale: motorbikes, cars, vans and boats. Each class of items for sale has different characteristics that need to be recor

Document view architecture, DOCUMENT VIEW ARCHITECTURE The Document/Vie...

DOCUMENT VIEW ARCHITECTURE The Document/View architecture is used to build an application based on the Microsoft Foundation Classes library. The Document/View architecture is s

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