Tag Archives: Open

How to Open Files Using VBA

Handling other files in VBA macros As a programmer, you’re likely to come across many situations where other files need to be opened for reading, writing, or appending data. A macro can help you easily handle these files, and the Open method is your ticket.

No Thumbnail

Tekla Open API: Insert Single Rebar

This article explains how you can add a single rebar to a concrete part in a Tekla Structure model using the Tekla Open API in VB.Net. – Step 1: Add reference to the Tekla.Structures.Model and Tekla.Structures library located in the path “C:Program FilesTekla Structures20.0ntbinplugins” and manually open

No Thumbnail

Access Startup Form

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can use an “Autoexec” macro to open a certain form every time the access file is opened. In this article another method will be explained. – Step 1: Click on the File button: –

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

No Thumbnail

Excel VBA, Reading Text Files

In this article I will explain how you can read data from a text file. You can download the workbook and code for this article here. Jump To: Example 1, Opening a Text File and Reading the First Line Example 2, Closing the Text File After Using

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

Open Form When Database is Opened, Access

This article explains how to cause a form to open when an Access database is opened. Step 1: From the Create ribbon click on the Macro button: The following window will open: Step 2: Select OpenForm from the drop down list: Step 3: From the

No Thumbnail

Open Blank Form When Database is Opened, Access VBA

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can cause a form to appear every time the an Access file is opened. By default the form will be displaying the first record in the table:In this article I will explain

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