MS Office blogs from Wise Owl (page 1 of 7)

Showing blogs 1-20 (out of 140)

Useful links and downloads for our video tutorials on Power BI applications

Posted by Andy Brown on 15 April 2015 | no comments

This blog is provided to support our series of tutorials on PowerPivot, Power Query, Power View and Power Map.

Once you've loaded a Power Query, how do you change your load options?

Posted by Andy Brown on 01 April 2015 | no comments

When you've created a Power Query in Excel, you can close it and load the resultant data. But how do you then change how the query loads? This blog explains how!

Installing the Microsoft Date and Time Picker for VBA

Posted by Andrew Gould on 24 February 2015 | no comments

Some versions of Windows don't include the very useful Date and Time Picker control. This blog explains how to install the mscomct2.ocx file to get it back!

Tags:   VBA macros | User forms

Using DAX Studio to edit calculated fields or measures in Excel

Posted by Andy Brown on 20 February 2015 | no comments

The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

How to insert ActiveX controls after CANNOT INSERT OBJECT message

Posted by Andy Brown on 29 January 2015 | no comments

When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!

VBA code to create a chart and textbox, and copy them to Word

Posted by Andy Brown on 03 October 2014 | no comments

Charts in VBA are a bit weird: this blogs highlights some of their foibles, by showing how charts are really just special shapes, which contain shapes of their own!

Programmatically searching websites using VBA

Posted by Andy Brown on 19 September 2014 | no comments

I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.

Tags:   Excel | Excel Visual Basic    |    VBA macros | References

Revealing how Excel workbooks are actually stored as zipped XML files

Posted by Andy Brown on 16 May 2014 | no comments

Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.

Tags:   Musings | Random musings    |    Excel | General

Flappy Bird in Excel VBA Part 13 - Playing Sounds

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial explains how to add sounds to the game using a Windows API function.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 12 - Managing Game State

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial implements a state system to make it easier to determine what actions to perform each time the game updates.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 11 - Detecting Collisions

Posted by Andrew Gould on 24 April 2014 | no comments

In this part of the tutorial you'll learn how to make the game detect collisions between the bird and the obstacles.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 10 - Creating Obstacles

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial shows you how to add obstacles to the game and how to make them move across the screen.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 9 - Creating the Game Sheet

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial explains how to generate a game worksheet using code to define the playing area.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 8 - Using Class Modules

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial introduces the concept of class modules and shows you how to use them to organise your code.

Tags:   VBA macros | Classes

Flappy Bird in Excel VBA Part 7 - Creating Sprites

Posted by Andrew Gould on 11 April 2014 | no comments

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.

Flappy Bird in Excel VBA Part 6 - Detecting Player Input

Posted by Andrew Gould on 11 April 2014 | no comments

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.

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

Posted by Andrew Gould on 11 April 2014 | no comments

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

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

Posted by Andrew Gould on 11 April 2014 | no comments

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

Flappy Bird in Excel VBA Part 3 - Windows API Functions

Posted by Andrew Gould on 11 April 2014 | no comments

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

Flappy Bird in Excel VBA Part 2 - Basic Workbook Setup

Posted by Andrew Gould on 11 April 2014 | no comments

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