Archive
Author Archive
Unicode conversion keyboard shortcut in Microsoft Word
2017/09/26
Leave a comment
A visitor asked me about the whereabouts of the uniqoder website that I recommended here – I am afraid I have lost track. But if you have Microsoft Word, at least you can always easily type Unicode using the conversion ALT-X keyboard shortcut
To retrieve a hidden Find Text window of MZ-Tools
2017/04/16
Leave a comment
- … close all your other undocked windows in VBE Editor.
- Must have been hidden during inadvertent docking and took me a while…
How to add multiple clips to the timeline in Expression Encoder – at once
2017/01/31
Leave a comment
- Expression Encoder is a great screen casting tool for Windows – and it is free.
- Except that in the free version, each clip is limited to 10 minutes. This can result in many clips that you nee to combine to document one session.
- Adding clips to the media and encode them does not roll over at the end of one to the next clip (different from as things used to Work in Windows Media Encoder) – it produces as many output files.
- Using the Add Source at End
. button seems to limit you to adding one clip after the other. 
- What I had missed so far: You can simply select multiple clips at once in the file open dialogue.
- Expression Encoder will add all to the timeline in sequence, and encode all to one output file:
Radar Chart visualizing Cost of Living in select US Cities
2016/11/06
Leave a comment
Source:Sperling’s
Categories: Charts, e-commerce, Media
charting, MS-Excel
Have your VBA Add-in autogenerate menus for easier access to your macros
2016/07/22
Leave a comment
- Storing your macros in add-ins (.xlam) has many advantages over personal.xlsm and similar document locations.
- One disadvantage however is that an Add-in macro is not accessible through the Excel macros dialogue.
- The community recommends assigning shortcuts for easy access. I did that and went a couple of steps further using VBE extensibility to
- depending on scope
- public procedures on your end users’ computer to whom you distribute your Add-in
- and also non-private on the developer machine
- list your modules alphabetically
- list your macros alphabetically under your modules
- for each, find & assign a free (free within Excel only – short of assigned windows-wide shortcuts since in my current work environment, I am unable run tools that allow you to list these shortcuts) shortcut combination,
- automatically generate an Add-Ins menu of all that , to serve as a cheat sheet.
- depending on scope
- Code TBA
Categories: service-is-documenting, service-is-programming, sourcecode
add-ins, MS-Excel, ribbon, VBA
Inserting Word Building Blocks from Template using Ribbon or QAT
2016/06/22
Leave a comment
Either insert from Ribbon / Insert / Quickparts: 
Or for extra speed and convenience, you can have your template store access to your building from the Quick Access Toolbar: 
Demo video is here.
Categories: office-software, training
building-blocks, MS-Word, qat, quickparts
Try “Stop Collecting” with Office Clipboard for Runtime Error 1004 “Paste Method of Worksheet Failed”
2016/05/30
Leave a comment
There seem plenty potential sources of error for method .Pastespecial, and a vast amount of questions and good advice online.
But I did not find this one, and only this one managed to make Pastespecial into Excel work for me. 
Questions? Read the About. Or just ask me a quick
FAQs for LRC student staff or for students or for teachers. To search our FAQs, in the browser addressbar, add after "https://plagwitz.wordpress.com/feed/?tag=faqs+/" "+TAG1" (from tag cloud below) OR "https://plagwitz.wordpress.com/feed/tag=faqs
&category_name=" "CAT1" (from category hierarchy below). OR search both categories and tags, and multiple TAGs/CATs (connect with "," for OR-search, with "+" for AND-search), like so: https://plagwitz.wordpress.com/feed/?tag=TAG1+TAG2+...TAGn&category_name=CAT1
+CAT2+...CATn"
Other ways to find help
If you cannot find it here, look there: 5,500 Language-Learning Links and Programs for learning or teaching 150 languages
Shortcuts:Our Lists, Our Maps, LRC Staff Moodle Site,LRC Project Moodle Site, 49erexpress, UNCC Moodle, Student Recordings: s:claslcslrcsanakostudent
Learning usage samples: Sanako oral exam, Kaltura webcam presentation, Dictation with speech recognition, Sanako written exam, Chinese and Japanese interactive stroke-order practice
Test the Sanako Installer, Webbrowser Popup Konfigurator for XP, or Windows7, faster LRC TeacherPC Log-in Let MS facilitate diacritics writing by installing for you US-International keyboard layout
This is my personal blog (Google+). The views expressed on these pages are mine alone and not those of my employer. The information in this weblog is provided “AS IS” with no warranties, and confers no rights.
Thomas' Work Space 