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
    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…

How to define your own conditional content marker “Internal” for Doxygen

  1. Doxygen comes with a built-in conditional content marker \internal the outputting of which can be controlled with the switch INTERNAL_DOCS in Doxygen’s config file.
  2. However, I could not get this to work as advertised in Doxygen 1.8.8.
  3. In cases of similar feature breakage, users are commonly advised to fix the error in the Doxygen source. If you, like I did, lack the time for that, here is a simple workaround which uses another built-in feature that an be controlled via  Doxygen’s config file:
  4. Define as one of the:
    ALIASES = "myinternal=\if myinternal <HR><kbd><em>" \
              "endmyinternal= </em></kbd> \endif"
    # HTML is optional, intended to make internal information stand out clearly if outputted
  5. Switch this ALIAS on and off using ENABLED_SECTIONS       = # myinternal
  6. Example usage in a .dox file:
    -# A high-low-high-low beep sequence followed by a low-high beep
     sequence indicates successful pairing and connection to the remote
     @myinternal tested with barcode on lower-end of cradle: gives success
     beep sequence @endmyinternal
     -# A long low, long high beep sequence indicates unsuccessful pairing.



Get every new post delivered to your Inbox.

Join 99 other followers