The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,519 other followers

Archive for the ‘Office’ Category

Infusion pump and PCA (patient-controlled analgesia) calculation

Posted by jpluimers on 2021/11/09

This is a great PCA calculator: [Archive.is] CADD calculator 0.5BETA END USER Google Docs – Google Sheets

Via:

Related:

–jeroen

Read the rest of this entry »

Posted in Development, Excel, Google, GoogleDocs, GoogleSheets, Office, Office Automation, Office VBA, Power User, Scripting, Software Development | Leave a Comment »

Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community

Posted by jpluimers on 2021/11/02

As it combines VBA and AppleScript, I might need the script from this in the future [WayBack] Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community.

–jeroen

Posted in Development, Office, Office 2011 for Mac, Office Automation, Office VBA, Scripting, Software Development | Leave a Comment »

Word: have part of Heading 1/2/3 not show up in the table of contents

Posted by jpluimers on 2021/10/01

Every now and then, for instance with a document including other documents, like in a homework assignment, you might want to exclude part of your Heading 1 (or Heading 2/Heading 3) entries from the table of contents.

Since presence in the Table of Contents is a ToC feature, not a style feature, you have to set the correct options in the ToC.

This is how you do it:

  1. Create new styles for the headings you do not want in the ToC (I call them “Heading 1, no ToC”; “Heading 2, no ToC”; etcetera) and base each on the corresponding style “Heading 1” or “Heading 2”

  2. Modify your Table of Contents to exclude these new styles (as they are automatically included)

This is contrary to many advices to use the “Reference” toolbar, then “Add Text” marked “Do Not Show In Table Of Contents”. That advice will remove the heading formatting completely and remove it from the navigation pane, so do not follow [WayBack] Quick Tip: How to exclude headings from the Table of Contents in Microsoft Word – jeffreykusters.nl.

The above solution both keeps the formatting, and the appearance in the navigation pane. It only disappears from the Table of Contents.

It is based on:

Following the above steps, you get styles like this:

Read the rest of this entry »

Posted in Office, Office 2010, Office 2011 for Mac, Office 2013, Office 2016, Power User, Word | Leave a Comment »

Microsoft Rosebud was MSDAIPP – Wikipedia

Posted by jpluimers on 2021/07/23

On an old system, I found some x86 installers with names like RbudLR.cab, RosebudMUI.msiRosebudMUI.xmlsetup.xml.

They appeared to be the (now deprecated and never released as x64): MSDAIPP – Wikipedia (Microsoft Data Access Internet Publishing Provider).

Searching for RosebudMUI many returned detection scams like solvusoft, but somewhere further down was this only meaningful result: [WayBack] What is the RosebudMUI AddOn in Visio 2007?

–jeroen

Posted in Office, Office 2010, Power User, Windows | Leave a Comment »

Winword: parts of the document with numbered, but other parts (Table of Contents, Summary) without numbering

Posted by jpluimers on 2021/06/11

Steps to have only the body parts of your Winword document Heading 1 numbered, but parts like Summary and Table of Contents without numbering.

Related:

Steps:

  1. Create a document with
    • some paragraphs of body text, intertwined with:
      • some paragraphs that should become numbered headings,
      • some paragraphs that should become non-numbered headings
      • room for a table of context
  2. Go to the “Styles” popup (keyboard shortcut Ctrl+Shift+Alt+S, or ribbon “Home” -> section “Styles” -> small button on the lower right of the ribbon section
  3. For each paragraph that should become a heading, apply style “Heading 1” (you can also use keyboard shortcut Ctrl+Alt+1 for this)
  4. Modify the various heading levels so they become numbered: see [WayBack] How to create numbered headings or outline numbering in Word 2007 and Word 2010 | ShaunaKelly.com. I prefer the hierarchical numbered multilevel list without the numbers being indented for the body text, but with indented numbers in the Table of Contents, so lets go.
    1. Start with the stock multi-leveled list definition:
      1. Change from “None” to the multi-level one:
      2. Now create a new one based on it:
        1. “Define New List Style…”:
        2. Rename from “Style1” to “Heading
    2. This involves creating a new list style called “Headings”, based on the numbered list style you like
      • ).
    3. Since by default, these bind to all levels, your document styles “Heading 1”..”Heading 9″ are covered. If for one or more styles, you do not want numbering, see below how to fix that (I do that for a “Heading 1 – no-numbering” style used for the “Summary” heading, and for the “TOC Heading” style.
  5. Mark the “Summary” heading as a new style “Heading 1 – non-numbered”:
    1. Press Ctrl+Shift+S to get to the “Apply Styles” 
    2. Enter the new name “Heading 1 – non-numbered” and press the “New” button: 
    3. Press the “Modify” button 
    4. to view the current style
    5. Press “Format” ->     
    6. Change it from “None” to “None” and press “OK”
    7.  Observe the numbering is gone:
    8. Unlike the “Heading 1” style, the “Style for following paragraphs” is wrong: it needs to be
    9. Now we are done, so press the “OK” button:
    10. Then observe the first numbered “Heading 1” now has got the number “1” instead of the “Summary”:
  6. Insert a “Table of Contents”, for instance after the “Summary”
    1. You might think it will start with a heading “Table of Contents”:
    2. Im some localisations of office, it is prepended with a “1.” and becomes “1. Table of Contents”. If it does, then you have to change style “TOC Heading” and undo the numbering as done with “Heading 1 – non-numbering” by pressing Ctrl+Shift+S when you are in the “Table of Contents” heading:
    3. From there, press the “Modify” button and continue as done with “Heading 1 – non-numbering”:

–jeroen

Posted in Office, Office 2007, Office 2010, Office 2013, Office 2016, Power User, Word | Leave a Comment »

 
%d bloggers like this: