Tag Archives: Excel

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

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.

No Thumbnail

Excel, Custom Formatting Semicolon Character

The semicolon character is a special character used in custom formatting. It basically acts as an IF statement, it checks for the following conditions: Positive numbers Negative numbers Zeros Text Values You can have upto 3 semicolons in a custom formatting. Note: The rules mentioned in this article

No Thumbnail

VBA Excel, Writing to a Text File

In this article I will explain how you can write data to a text file. Jump To: Example 1, Write One Line of Data to Text File Example 2, Write Multiple Lines of Data to Text File Example 3, Save File Dialog Example 4, Check

No Thumbnail

VBA Excel, Hyperlink to Google Earth (Google Earth API)

This article explains how you can create a hyperlink in Excel to a google earth location. When the user clicks on the hyperlink google earth will launch and move to the specified location. In the figure below you can see the excel sheet with the hyperlinks: In

No Thumbnail

Excel VBA, Get Data From Web Using MSXML

Previously in the article below I’ve explained how you can get data from the web using query tables in VBA: Excel VBA, Retrieving Data From a Website Using a Query Table The problem with using Query Tables, is that they are slow. A faster method

No Thumbnail

VBA, Open Access Database From Excel

In this article I will explain how you can open an existing Access database from Excel using VBA. If you wish to only import the data into excel you could use the topic covered in the article below: Excel Connect To External Data (Access Database ) In