Category Archives: VBA

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

RangeFindSample

When Should You Use the VBA Range.Find Method?

The Range.Find method is basically used to find specific information within a range. It has various types of attributes that can be used depending on the required values. It will return a Range object that represents the first cell where the information is found. Syntax expression .Find(What,

RangeSelect_Sample1

How to Maximize Your Use of VBA Range.Select Method

The Range.Select method is used by VBA Macro developers for various purposes. These can be as simple as selecting a cell on an active worksheet, selecting one on another worksheet, or selecting a range of cells on a worksheet from a different workbook. Sample code #

RangeCopy_Sample3

Why is the VBA Range.copy Method Useful?

The Range.copy method is simply used to copy a range into a specified range or the clipboard. This is commonly used when you have specific data range within the worksheet that you want to copy. It can also be used to copy a formula from

RangeCells_Sample6_After

What is VBA Range.Cells and How Do You Use It?

This property can be used to select a Range. It returns a Range object that represents the cells. It refers to the cells of the specified range object, which can be a worksheet or a range of cells. It requires two parameter values “RowIndex” and

Access Word Objects through Excel VBA

In this article, we will see how to access the various word objects using VBA in Excel and insert data from Excel to Word. This has many practical applications such as when you have to fill out a form multiple times with data from Excel or

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

privacy policy