Tag Archives: FIle

The Excel VBA Application.FileDialog Object

Have you ever wished you could develop a simple way for users to select files to open from within Excel? Perhaps you want to impose a level of control over which file path users select the file(s) from. This can be done by using the

No Thumbnail

Open KML File Using VBA for Excel (Google API)

This article explains how you can use VBA for Excel to open a KML File. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note

No Thumbnail

Access VBA, Get KML File Data (Google Earth API)

This article explains how to get data from a KML file using VBA for Access. KML files are basically XML files, therefor the process is basically the same as getting data from any other XML File. The method uses the MSXML object. I’ve explained how

No Thumbnail

VB.Net Open KML File (Google API)

This article explains how you can use VB.Net to open a KML File. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the version might

No Thumbnail

Open KML File Using VBA for Access(Google API)

This article explains how you can use VBA for Access to open a KML File. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the

No Thumbnail

Excel, Get KML File Properties, Google Earth API

This article will explain how you can get the different properties of a KML file in Excel. This includes properties such as: Longitude Latitude Headin Tilt Range … – Step 1: Bring the Developer Ribbon. – Step 2: Click on the Imports button: – Step 3: From

No Thumbnail

VB.NET Get KML File Properties (Google Earth API)

This article explains how to get the different properties from a KML file using VB.Net. Properties such as: Longitude Latitude Altitude Range … – Step 1: The first step would be to add reference to the Microsoft XML library. I have Microsoft XML V6.0 installed