BrizBunny Rotating Header Image

Odds & Ends

Things that don’t have a home anywhere else

Resume Excel 2013 Open Workspace

Okay, so the last post about partially regaining the Save Workspace function in Excel 2013 didn’t set the world on fire.

There was one thing missing though. In order to get your collection of Excel files open again you had to have a file open, even if it was just a blank workbook. I found this a little annoying once I got over the jubilation of getting the Save Workspace function back.

A solution was found in the form of a bit of VB Script, in effect a Windows batch file (.vbs rather than .bat).

set objExcel = CreateObject(“Excel.Application”)
objExcel.visible = true
objExcel.Application.DisplayAlerts = true
myStartUp = objExcel.Application.StartupPath
objExcel.workbooks.Open myStartup & “\PERSONAL.XLS”
objExcel.Run “personal.xls!OpenWorkSpace2013
set objExcel = nothing

Open Notepad and paste in the code above. Then save the file with a “.vbs” extension somewhere easy to get to, like your Desktop. When you click on the file Excel will open with your saved workbooks. You may need to update the name that you gave the macro that Opens the Workspace file; “OpenWorkSpace2013” in this case

Excel 2013 – Save Workspace

With the leap up to MS Office 2013 at work I have discovered the “joys” of the ribbon. After a while I have decided that I can live with it, everything just takes more time – where was that; and, where can they have hidden it now.

One thing that did stick out though was that Microsoft had discontinued the Save Workspace function in the Office 2013. Save Workspace would create a file (*.xlw) based on the currently open workbooks and their layout. This is useful if you are in the middle of something and are interrupted. When you get back just click of the workspace file and everything is back to the way it was. (more…)


“If you are going to live your life in Technicolor, then you have to expect some spilled paint.” Air Commodore John Oddie (Retd.)



I have touched upon procrastination a little in the past. Today I found out that there is a formula that explains the psychology of motivation and procrastination [^].

Motivation Equation

In other words, if a we have a reasonable sense that something is achievable (expectancy), the pay-off is going to be high (value), the activity was planned (not impulsive) and the timeframe is short (low delay) then motivation should be high. As soon as any of these factors start to move then the motivation and chance of procrastination will also change. Any one of these factors can have a big impact on the way that someone reacts to the task.


“How lucky I am to have something that makes saying goodbye so hard”
AA Milne – Winnie the Pooh

Winnie-the-Pooh and Piglet