Data Processing Archives - VBA and VB.Net Tutorials, Education and Programming Services

Category Archives: Data Processing

A Complete Guide to Loops in VBA

When you write good VBA code, you try not to repeat yourself too often – in other words, you try not to write the same code for repetitive tasks more than once.  Looping structures are an invaluable part of VBA and you will use them

VBA List – A Powerful Tool for Processing Tables in Excel

The ListObjects property of the Worksheet object returns the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet. The ListObject object is a member of the ListObjects collection. Each ListObject object represents a table (previously known as a list) in the worksheet. An

AccessBefore

Updating Tables in an Access Database Using Excel VBA

In this article, we will see how to update records in Access database through Excel VBA using ActiveX Data Objects (ADO). Let’s say you have a database named “Products". In that database, there is a table “ProductTable" that contains the product details of your business

Excel data for PowerPoint

Accessing PowerPoint controls through Excel VBA

Creating a PowerPoint presentation using data from Excel is very common. You can simply create a new PowerPoint, copy all the data, and you’re done. But consider a periodic report — a sales report, for example. Each month you need to create a PPT with data in

No Thumbnail

Searching Data In Excel Sheets

One of the main tasks an Excel VBA programmer encounters is searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In

No Thumbnail

Referencing Ranges In Excel Using VBA

In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,

More To Explore