Programming blogs from Wise Owl (page 2 of 7)

Showing blogs 21-40 (out of 133)

Flappy Bird in Excel VBA Part 7 - Creating Sprites

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to draw simple images using a worksheet as the canvas. You'll also see how to include the images in the game.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 6 - Detecting Player Input

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to respond to keys pressed by the player. You'll learn about the Application.OnKey method and the GetAsyncKeyState Windows API function.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 5 - Starting and Ending the Game

Posted by Andrew Gould on 11 April 2014

This part of the tutorial adds a basic menu system with ActiveX command buttons to start and stop the game.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 4 - The Game Timing Loop

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to set up a timing loop which allows the game to update continuously.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 3 - Windows API Functions

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to make use of Windows API functions to extend the power of Excel VBA.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 2 - Basic Workbook Setup

Posted by Andrew Gould on 11 April 2014

This part of the tutorial describes how to setup a basic workbook ready for you to start coding the Flappy Owl game.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA Part 1 - Introduction

Posted by Andrew Gould on 11 April 2014

This part of the Flappy Bird in Excel VBA Tutorial introduces you to the Flappy Owl game and provides download links and instructions to get it running in Excel on your machine.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

Flappy Bird in Excel VBA - Tutorial Index

Posted by Andrew Gould on 11 April 2014

This is the main index page for the Flappy Bird in Excel VBA tutorial. Here you can find links to all of the articles which comprise the tutorial.

Tags:   Writing VBA | Flappy Owl    |    VBA macros | Flappy Owl

How to create autoshapes, lines and connectors in VBA macros

Posted by Andy Brown on 25 January 2014

You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!

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

Advice on how to scrape tables of data or HTML from webpages using VBA

Posted by Andy Brown on 13 January 2014

You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").

Tags:   VBA macros | References    |    Writing VBA | Other

Getting the Calendar control to work in Excel 2010 onwards

Posted by Andy Brown on 13 January 2014

The calendar control for user forms is built into versions of Excel up to 2007, but has to be imported for later versions - this blog shows how to do this!

Tags:   VBA macros | User forms    |    Writing VBA | Other

Triggers in SQL Server

Posted by Andrew Gould on 27 November 2013

Triggers are special stored procedures that execute automatically in response to certain events in a database. This blog explains how to create three types of trigger in SQL Server: DML, DDL and Logon triggers.

Tags:   SQL | Triggers    |    T-SQL | SQL Tutorial

How to use environment variables like USERNAME in VBA

Posted by Andy Brown on 25 November 2013

You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.

Tags:   VBA macros | Variables, arrays    |    Writing VBA | Other

How to loop over enumerations in VBA

Posted by Andy Brown on 07 November 2013

A short blog explaining how to use Visual Basic for Applications to loop over enumerations.

Tags:   Writing VBA | Other    |    VBA macros | Enumerations

Transactions in SQL Server

Posted by Andrew Gould on 11 October 2013

This blog examines how to use Transactions in Microsoft SQL Server to allow you to control when data changes are committed to the database. You'll also discover how you can rollback transactions, effectively giving you the chance to undo changes to your data.

Tags:   SQL | Transactions    |    T-SQL | SQL Tutorial

How to use the LAG and LEAD functions included in SQL Server 2012

Posted by Andy Brown on 20 September 2013

SQL Server 2012 introduces new functions to find the previous or subsequent value for a row, without using a complicated self-join. This blog explains how to use LAG and LEAD, including partitioning row sets.

Tags:   SQL | Calculations    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

Wise Owl suggestions for new features for SQL Server Management Studio

Posted by Andy Brown on 09 September 2013

Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!

Tags:   SQL | General    |    T-SQL | New features

How to debug T-SQL queries and stored procedures

Posted by Andy Brown on 06 June 2013

This blog gives the low-down on how to start and use the debugger included in SQL Server Management Studio 2008 R2 and SSMS 2012.

Tags:   SQL | Errors, debugging    |    T-SQL | SQL Tutorial

Want to wind up your neighbour? Try this annoying Excel VBA code!

Posted by Andy Brown on 14 May 2013

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Tags:   Writing VBA | Other    |    VBA macros | Events

Deleting and Updating Records in SQL

Posted by Andrew Gould on 08 May 2013

This blog teaches you how to modify existing data in your database by either deleting records or updating them.

Tags:   SQL | Transactions    |    T-SQL | SQL Tutorial
This page has 0 threads Add post