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

For next repetition - control statement, For ..... Next Repetition Statemen...

For ..... Next Repetition Statement: To demonstrate the working of for .. next control statement, put a command button and a label control on the form. The Handle clicks the e

Data types - visual basic, DATA TYPES   The different primitive data t...

DATA TYPES   The different primitive data types are Boolean, Char, Byte, Date, Decimal, Uinteger, Double, Integer, Long, Sbyte, Short, Single, String, Ulong & Ushort. To decla

Vb script coding conventions, Coding conventions are recommended that may h...

Coding conventions are recommended that may help you write code via Microsoft Visual Basic Scripting Edition. Coding conventions can include the given: Naming conventions for ob

Collection is adding last record, Please help me.. I am loading data from ...

Please help me.. I am loading data from a text file to a class (Item Inventory from Tony Gaddis - Visual Basic - Chapter 12 -programming challange# 7-9) and the last item loaded is

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

Record set - database applications, Record Set: The record set present...

Record Set: The record set presents the records in a base table or the records retrieved due to the query. The record set falls into 3 classes. These are table type record set

ER DIAGRAM FOR DISTRIBUTER MANAGEMENT, HOW TO MAKE ER DIAGRAM FOR DISTRIBUT...

HOW TO MAKE ER DIAGRAM FOR DISTRIBUTER MANAGEMNET OF WATER PURIFIAR

Properties of object method, Properties: VBScript Err Object ...

Properties: VBScript Err Object   Properties   Description   D escription Property The descriptive string related

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