Excel VBA, Export Worksheet to Blank Access Table

In this article I will explain how you can export values from an excel worksheet to a new blank Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we

No Thumbnail

Excel VBA, Fill Pattern

Various different patterns can be applied to cells in Excel. These patterns can be applied manually using the Format Cell dialog: This article will explain how you can apply different patterns to cells using VBA for Excel. Jump To: Basics Example 1, Set Pattern Example

No Thumbnail

Excel VBA, Column Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Column: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

Word VBA OverFlow Error When Multiplying/Adding Integers

It might have occurred to you when working with integers in VBA for Word that you get  the following error: This error generally occurs when  you are doing arithmetic operations on integer values that result in: Values larger than 32767 Values smaller than -32768 This is because integers only

No Thumbnail

Word VBA, Assign Shortcut Key to Macro

This article explains how you can assign a shortcut key or key combination to a macro. – Step 1: Press the “File” button on the top left of the word application, then click on options:   Note: In word 2007, there will be an “Office

No Thumbnail

Excel VBA, Sheet Reference Speed

In the article Excel VBA Working With Sheets, I’ve explained that there are 3 different methods for referencing sheets. I have run tests on these methods to determine the fastest way of referencing sheets. Before explaining the tests, I have briefly explained the different methods of referencing sheets.