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”
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
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 [^].
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.