This article explains how you can use VBA for Excel to automate Google Earth and set the camera to the location you want. It will be assumed there is KML file located in the path “D:StuffBusinessTempLocation.KML”. The KML file contains the required data for setting the camera
In this article explain how you can write an excel application to retrieve currency exchange (forex) rates from the website http://finance.yahoo.com/. This application also allows users to select only the currency exchange (forex) rates he/she needs. You can download the codes and files related to this article
In this article I will explain how you can use VBA for word to crop images. The first step is to determine the type of image. There are 2 types of images: Inline Floating I’ve previously explained about the 2 image types in the article
In this article I will explain how you can create a table in an external access database using VBA. Before creating a table you will need to connect to an external database. You could either create a blank access database using the topic covered in
In this article I will explain how you can get the names of all the tables in an external access database using VBA. The first step would be to connect to an external database. I’ve explained this in the article below: VBA, Open Access Database From
The Next Record Field is not visible by default: In order to delete the Next Record Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXT Field: Step 3: Delete it: See also: Word, Mail Merge
In this article I will explain how you can open a word document using VBA. – Opening Word Document: If you are opening a word document from word you can use the code below: Sub main() Documents.Open (“D:TestFolderMain.docx”) End Sub Where “D:TestFolderMain.docx” is the path where the word
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, Row: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples
If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples – Example
You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.