How to prevent OneNote from crashing when hovering over search results

  1. Problem: In a strange new development, my OneNote crashes (multiple times, until things eventually become stable again) when I search my notebooks  from the upper right search box. Specifically, as soon as I hover my mouse over the search results display.
  2. My environment: OneNote 2013 32-bit on Windows 7 64-bit. These are notebooks on a network share, and they are updated from multiple machines. Not aware of any recent changes to my mouse settings or drivers.
  3. My Workaround: Navigate the search results using the keyboard. This seems to prevent those crashes.

I’ll see you on the dark side of the moon…

 
      ... ove mirabilmente era ridutto
      ciò che si perde o per nostro diffetto,
      o per colpa di tempo o di Fortuna:
      ciò che si perde qui, là si raguna.

Will pass us by and you’ll never have to see it again, okay? – So it won’t hit us? – Not a chance.

You are receding. Before you know it you’re frozen. Until 2033, 50th.

Categories: Personal

How to split an Excel workbook into one file per sheet with VBA (reworked)

  1. There are other code snippets on stackoverflow.com, but I went with the top match in the Google search.
  2. Couldn’t get it to work (error # 424 Object required on xWS.copy in Excel 2013, with the VBA run from a separate utilities workbook) until I made these changes:
'TRP reworked http://www.extendoffice.com/documents/excel/628-excel-split-workbook.html
Sub Workbook_Split() 'Updated by TRP 20150924

    Dim xPath As String
    Dim myWorkSheet As Worksheet
    xPath = Application.ActiveWorkbook.Path 'the source workbook needs be saved first
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False

    For Each xWS In ActiveWorkbook.Sheets    'trp: replaced ThisWorkbook.Sheets
        'trp: replaced xWS.Copy 'toask: this fails with 424: object required
        Set myWorkSheet = xWS
        myWorkSheet.Copy 'If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet.
        Application.ActiveWorkbook.SaveAs FileName:=xPath & "\" & myWorkSheet.Name & ".xlsx" 
        'trp: replaced xWS.Name & ".xls"
        Application.ActiveWorkbook.Close False    'trp:savechanges:=False
    Next
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
End Sub

“"Mira, mamá! Sin manos!". Can speech recognition tools be soundly applied for L2 speaking practice?” FLEAT VI, August 11-15 at Harvard University

How to easily rearrange your sections via the headings in MS-Word’s Navigation Pane

  1. Short answer Show Navigation (from ribbon ./ View), then Drag&drop/
  2. word-navigation-pane-drag-headings
  3. Maybe obvious, but had escaped me so far – I thought such ease would only come only with outline view  – what a great feature!

Which UML diagram types are in most demand?

  1. From a recent spot check of over 500 job postings on Indeed.com that mention both “UML” and “diagram”, the following picture emerges:
  2. There is clearly a Big 4 of UML diagram types, and they are  – in order of frequency –
    1. sequence,
    2. use-case,
    3. activity and
    4. (the only structural diagram type that “counts”) class diagram.
  3. UML Diagram Type Count of type
    activity 19.33%
    class 15.33%
    communication 6.00%
    component 2.67%
    interaction 1.33%
    network-architecture 1.33%
    object 2.00%
    sequence 23.33%
    state 8.00%
    timing 0.67%
    use-case 20.00%
    Grand Total 100.00%
  4. It seems you could in practice cover “80%’ of UML with these four diagram types. Even state and communication  (collaboration) diagrams are an already very distant 5th and 6th (but get you up to a coverage of about 95%).
  5. Notably, the majority of UML diagram types – at least in this sample set – do not figure at all:
Count of type Diagram
0 Behavioral state machine
0 Collaboration use
0 Composite structure
0 Deployment
0 Information flow
0 Interaction overview
0 Internal structure
0 Manifestation
0 Model
0 Package
0 Profile
0 Protocol state machine

Note: The vast majority of mentions did not need any, but I attempted some translations of the raw data on indeed.com:

indeed.com counted as
action activity
collaboration (1) communication (2)
data flow information flow
domain model class diagram
object models object
state charts state machine
process flow 1 not counted
swim lane sequence
prototypes 1 not counted
Categories: service-is-documenting Tags:

How to ease editing work in MS-Word by automating search/replace operations

  1. If you frequently have to edit documents according to a large number of editorial rules and regulations
  2. and if you can partially automate these edit operations  (or at least highlight suspicious passages for human review) with Word’s search/replace,
  3. I can recommend an add-in that can automate even the repeated search/replace operations (like the 57 in the video below)
  4. and even help you manage your search/replace strings and regular expressions in a spreadsheet which it can load from:
  5. Greg Maxey’s VBA Find & Replace Word Add-in. See it in action (click for full size):
  6. vbareplace
  7. Two Three Caveats: :
    1. At this point, I cannot get the add-in to work only in Word 2010. Even if I lower Macro security and allow programmatic access to the VBA project, when trying to launch the add-in from the ribbon, Word 2013 complains: “The macro cannot be found or has been disabled due to your macro security settings”:image.
    2. The automation is only as good as your underlying search/replace operations. (Hint: “Some people, when confronted with a problem, think ‘I know, I’ll use regular expressions.’ Now they have two problems.”)
    3. I think I will refrain from search/replace during “Tracking changes” – as in the video – , and rather use “Compare documents” after the replace operations – too many quirks otherwise…