Programming blogs from Wise Owl (page 6 of 7)

Showing blogs 101-120 (out of 133)

Dates and Times in SQL Server

Posted by Andrew Gould on 13 February 2012

Dates and times can be the most frustrating data types to work with in SQL Server. Learn everything you need to know about the way dates work with this handy blog series and enjoy happier times!

Tags:   SQL | WHERE criteria    |    SQL | Calculations    |    T-SQL | SQL Tutorial

Passing arguments to subroutines in VBA

Posted by Andy Brown on 09 February 2012

To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.

Linking to ADO databases with VBA

Posted by Andy Brown on 06 February 2012

Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Copy, rename, delete and move files and folders

Posted by Andy Brown on 23 January 2012

By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.

Reading and writing to/from a text file using TextStreams

Posted by Andy Brown on 13 January 2012

The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.

How to choose files and folders in VBA

Posted by Andy Brown on 13 January 2012

To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

Linking to the Microsoft Scripting Runtime library

Posted by Andy Brown on 13 January 2012

In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!

Creating references programmatically in VBA

Posted by Andy Brown on 03 January 2012

Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Using CreateObject and GetObject to create references

Posted by Andy Brown on 09 December 2011

Although it's usually easiest to create references to other applications using the Tools/References menu as described in an earlier blog, you can use the method shown in this blog instead.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Referencing Word and other applications in Excel VBA

Posted by Andy Brown on 05 December 2011

Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Error-handling and error trapping in Excel Visual Basic macros

Posted by Andy Brown on 29 November 2011

What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.

Debugging macros in Excel Visual Basic / VBA

Posted by Andy Brown on 25 November 2011

This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.

Event-handling macros in Excel Visual Basic

Posted by Andy Brown on 22 November 2011

Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!

Tags:   Writing VBA | VBA tutorial    |    VBA macros | Events

Looping in Visual Basic for Applications macros

Posted by Andy Brown on 15 November 2011

There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.

Conditions in Visual Basic for Applications - IF and SELECT CASE

Posted by Andy Brown on 15 November 2011

This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.

Collections, objects, methods and properties in Excel VBA

Posted by Andy Brown on 09 November 2011

Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!

Tags:   VBA macros | General    |    Writing VBA | VBA tutorial

Common Table Expressions (CTEs) - SQL Training

Posted by Andy Brown on 20 October 2011

This blog gives training on writing CTEs in SQL, or Common Table Expressions to give them their full title. The blog also includes a section on creating recursive CTEs.

Tags:   SQL | CTEs, subqueries    |    T-SQL | SQL Tutorial

Temporary Tables in SQL - a Training Blog

Posted by Andy Brown on 20 October 2011

If you want training in how to use temporary tables in SQL, read on! This blog shows how to create temporary tables and how to drop them safely whether or not they exist. Finally, the blog lists the pros and cons of using temporary tables in SQL.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

Why you should program in Visual Basic, not Visual C#

Posted by Andy Brown on 10 October 2011

If you're beginning .NET application development with a clean slate, you'll need to choose a programming language. VB or C#? This opinionated blog gives you some guidance!

Tags:   Visual Basic | General coding    |    Visual C# | General

Using the InputBox Function in VBA Macros

Posted by Andy Brown on 03 October 2011

The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!

This page has 0 threads Add post