BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl blogs written in 2011 (page 1 of 3)
Showing blogs 1-20 (out of 53)
Ten Useful Applications That You Can Get For Free
Posted by Andrew Gould on 15 December 2011
As Christmas 2011 approaches we thought it would be a nice idea to list some geeky gifts that you can give to yourself. And the best thing is that they're all completely free!
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.
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
Posted by Andrew Gould on 02 December 2011
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
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!
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.
How to Create Custom Charts in Microsoft Excel
Posted by Andrew Gould on 10 November 2011
One of the most time-consuming things when creating charts in Excel is having to format them. This blog shows you how to save and reuse custom charts to ensure that you'll never have to format a chart again!
Setting the Default Chart Type in Microsoft Excel
Posted by Andrew Gould on 10 November 2011
When you create a chart, by default Excel always tries to give you a boring old column chart. If you primarily create pie charts it can be really annoying having to change the chart type every time you create one. This blog shows you how to set Excel to always create the type of chart that you want.
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!
Differences between Report Builder and Reporting Services
Posted by Andy Brown on 07 November 2011
Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.
Multivalue parameters in Reporting Services
Posted by Andy Brown on 07 November 2011
This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.
Install Report Builder 3.0 despite .NET 3.5 Framework error
Posted by Andy Brown on 31 October 2011
Struggling to install Report Builder 3.0 because of a message about the .NET 3.5 framework? The problem is more likely to be to do with Internet Explorer 9.0, as this blog explains.
How To Create Custom Date Formats in Microsoft Excel
Posted by Andrew Gould on 31 October 2011
When you enter dates into cells in Microsoft Excel you're initially limited to a short list of fairly boring formats. Using custom date formats means that you can display your dates in almost any way you like!
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.
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.
Using Icon Sets for conditional formatting in Microsoft Excel
Posted by Michael Allsop on 19 October 2011
This article looks at one of the new features in Conditional Formatting in Excel which we can use to make our boring lists more interesting!
Conditional formatting with Data Bars in Microsoft Excel
Posted by Michael Allsop on 19 October 2011
Following on from the article discussing simple conditional formatting in Excel, this blog shows you how to add Data Bars to your lists for that extra bit of pazazz!