VBA icon

Read XML files using DOM

In Create XML files using DOM we reviewed a method for creating XML files using worksheet data. Now let's go over a method for importing them back into Excel.

Continue Reading: Read XML files using DOM »

VBA icon

Create XML files using DOM

Some of you may be familiar with my Random Data Generator addin. Currently, one of the output formats is Microsoft's proprietary XML Spreadsheet format.

One of my goals is to increase the number of available output formats by including standard XML. Here is one way to save worksheet data as XML.

Continue Reading: Create XML files using DOM »

VBA icon

Google URL Shortener API

Google has it's own URL shortener with an API you can connect with programmatically. Let's go over some methods we can use to do so.

Continue Reading: Google URL Shortener API »

VBA icon

Bing Translation API Update

In Translation services using Bing API I posted a method for calling Microsoft's translation API. I have an alternative piece of code that accomplishes the same thing.

Continue Reading: Bing Translation API Update »

VBA icon

Which is faster, ByVal or ByRef?

This article is not intended to be an exhaustive evaluation of ByVal and ByRef, but merely a simple comparison of the relative speed of both keywords in identical procedures with various data types.

Continue Reading: Which is faster, ByVal or ByRef? »