July 28, 2021

Blogger: How to make width fit to the whole screen

I have noticed that my blog wasn't fitting to the screen width means I could not see the whole content horizontally on the screen and had to use the horizontal scrollbar. The right column wasn't visible without scrolling.

I have looked for a fix and found this one.

July 23, 2021

Blogger Pitfall: Sidebar moved to the bottom

I've found today an issue in my blog: from the homepage listing a list of posts, the sidebar was not visible as expected to the right.In fact it was moved to the bottom of the post.

July 14, 2021

How to send an email to a MS Teams Team

In some cases to raise awareness upon a critical topic it might be useful to go for a more pushy approach and send an email to all people members of a Microsoft Teams Team. (Alternatively, you could send a message in Teams with a banner, title and high importance but you can't be sure it will be read or handled like an email.)

You can do this conveniently in Outlook by sending an email to the Group behind the Microsoft Teams Team.
The group shall have the same name as the original (means at the Team creation time) Team.
But there is a pitfall here you have to be aware of. Read further below.

July 1, 2021

Jira: Global Dashboard Filter

In Jira Dashboards there is no possibility to apply a filter over all Dashboards elements aka. gadgets.
I present here a workaround/ best practice to provide what I call a global filter to a Jira Dashboard.

June 25, 2021

AutoHotkey: Error conditional call to nonexistent function

I have stumbled upon an annoying issue in AutoHotkey: I wanted to call a function in a library only if the corresponding library file was existing. Unfortunately, when running the script I got an Error: Call to nonexistent function

May 17, 2021

Quick Login with AutoHotkey

In this post I share a AutoHotkey script for quickly logging in.

Improve your writing in English

I collect in this post some recommendations to improve your writing in English.

May 10, 2021

Teams Pitfall: Flashing Taskbar

I have set my Windows Taskbar to auto-hide. (Settings -> Automatically hide the taskbar)
Now Microsoft Teams Client keeps flashing the Taskbar on new messages although I have reduced the notifications down to the minimum/ only to feed/ no banner.
This is super annoying i.e. an accessibility issue because I then can not access the screen covered by the flashing taskbar - until I have selected the Teams client window.

Jira to PowerBi (Improved version)

I have worked on an improved version for importing a Jira filter into Microsoft PowerBI.
Main advantage of the new approach is that it will import only the fields as defined in your filter columns and also the expanding and renaming from internal field names to display names is done automatically. (WYSIWYG)

Handling of Password storage in AutoHotkey

I share in this post different ways of handling password storage in AutoHotkey.

May 7, 2021

Jira to PowerBI (List based version)

This post is a bit obsolete and was superseded by this version. I prefer a recursive approach to this List / Loop based one. The recursive approach doesn't require to check before for the total number of issues and is more generic for any Rest Api Pagination handling (e.g. HCL Connections export)
I keep this post here for reference.

I have worked on an improved version for importing a Jira filter into Microsoft PowerBI. (My previous solution with a recursive approach wasn't working anymore.)
Main advantage of the new approach is that it will import only the fields as defined in your filter columns and also the expanding and renaming from internal field names to display names is done automatically. (WYSIWYG)

April 28, 2021

How to delete images from blogger

I had to search for this one for removing images in my blogger blog that may contain personal data.

April 23, 2021

Opening AutoHotkey Help from any editor

I have this week found out a better way to open the AutoHotkey help based on current selection/ context. (thanks to RaptorX and Joe the-Automator.) This is based on AHK Help Launcher.

April 20, 2021

Share nice Confluence links

There is one pitfall to know when sharing Confluence page links so that the links are permalink i.e. robust to renaming. Secondly how cool would it be to be able to paste a Confluence page url and have it automatically converted into a nice-looking rich-text link including the page title and related space information? I present here a solution based on AutoHotkey and implemented in the NWS PowerTool IntelliPaste feature, just to do this.

April 16, 2021

Opening AutoHotkey Help from Visual Studio Code

I am using Visual Studio Code as code editor for my AutoHotkey development. I was looking for an easy way to open the AHK documentation about a selected command from the editor. Here is my final solution.

April 15, 2021

Google Analytics 4 for Blogger keeping Universal Analytics

I have tried to update my Blogger blog to the new Google Analytics tracking (GA4). But I have noticed that my old tracking with Universal Analytics was discontinued (data won't be fed).
Here is the solution I have come to fix it and keeping using UA and GA4 tracking in parallel.

April 12, 2021

AutoHotkey: Paste and restore clipboard pitfall

I have stumbled about a paste pitfall in AutoHotkey and seen recently in Reddit I am not alone ;-)
I have learned also recently from an AHK Forum post (thanks to rommmcek) how to handle properly such issue.
I share here my learning and Clipboard code library.

Teams Shortcuts: Mute on/ off

Previously I had implemented in the Teams Shortcuts PowerTools only the functionality to Toggle the mute state. (There is only a native hotkey to toggle.) Now I have improved the implementation to also mute on and off. This is based on the FindText AutoHotkey.

April 9, 2021

Quick YouTube Channel Search (AutoHotkey Tutorial)

Today I wanted to quickly search for videos inside a specific YouTube Channel.
The prominent search bar would search in whole YouTube. The search for the channel only is a bit hidden.
I share here how I have implemented a Quick Search functionality in the NWS PowerTool based on AutoHotkey.
This is more a on the fly implementation recording post.

How to create a Public location in your OneDrive

I share in this post how you can open a folder in your OneDrive for access to all your colleagues and easily share files without caring about creating shared links.

Google Sheets Tricks: Copy formula to whole column

I have learned this tricks in Google Sheets:

Drag and drop all the way down of a column can be a bit cumbersome.

To select all the cells below another one, you can use the hotkey Ctrl+Shift+Arrow Down.
Then you can for example copy/ paste on this whole selection.

To copy a formula in the whole row, you can edit the first cell and use an ArrayFormula

Example : 

=ARRAYFORMULA(IF(ISBLANK(E2:E);"";YEAR(E2:E)))

When you do so the cells must be empty else you will get an error that the formula would overwrite the existing value.

April 8, 2021

Teams pitfall: Sharing control with different keyboard layouts

I have encountered recently a very annoying bug (yes, this is definitely not a feature) in Microsoft Teams meetings. I was taking over the control on another PC via Teams to edit a Word document on his PC. While typing in Word the letters rendered did not match to what I was typing. (I guess because my colleague has an other keyboard layout than mine. I have a German keyboard. He has an English one.)

April 7, 2021

Quick Google Site Search in the Browser

I have extended the NWS PowerTool Quick Search feature: you can now in a browser quickly fire a Google search that restricts the results to the current site.

April 6, 2021

Handling of Open calls/webinars (Connections/ Outlook/ Teams)

I share here a best practice how to handle open calls, webinars or any events if you are also using Microsoft Outlook and Microsoft Teams and want to share the event in an open platform like HCL Connections ESN. (without inviting your whole company via Outlook; pull vs. push)

April 1, 2021

AutoHotkey: Microsoft Teams Get active meeting window without user prompt

The previous solution I have shared to identify the current Microsoft Teams meeting window with AutoHotkey would prompt the user to finally validate the window - in case you have meetings in parallel e.g. with one on hold. I share here a way to skip this user prompt / fully automate the meeting window detection.

March 31, 2021

AutoHotkey Tutorial: using FindText to implement shortcuts for Microsoft Teams Meeting Actions (e.g. toggle Full Screen)

I explain in this blog post including screencast, how to implement any shortcut with the AutoHotkey FindText function. Example is for Microsoft Teams and specially a Meeting Action like Toggle Full screen.

March 24, 2021

How to rename All Web Site Data in Google Analytics

I have been playing around with Google Datastudio for reporting my blog and AHK Homepage metrics.
I want to use the same report for both data sources and simply switch the data source in the report.
Unfortunately both data sources are shown as "All Web Site Data" and it is hard to identify.

March 23, 2021

How to copy/ duplicate a google analytics dashboard

I have been looking for this one: How to copy/ duplicate a google analytics dashboard

March 19, 2021

GitHub: How to download a single folder

For setting up the powertools I have been looking for a solution to download a whole folder (including subdirectories) from a GitHub repository. I share here my final solution/ learning.

Blogger: Set up Google Analytics to new dynamic tag (gtag.js)

I got this email by Google Analytics:

I thought my Blogger blog was properly set, but checking at the page source code it wasn't.

March 12, 2021

Microsoft Teams: Shortcuts for Meeting Live Reactions? -> yes! (thanks to AutoHotkey)

Update 2021-03-31: I have changed the implementation, replacing ImageSearch by FindText. See technical background in this post. It is more robust than the solution explained below and does not require to store screenshot image files.

Microsoft Teams has introduced recently live meeting reactions (like Laugh, Like, Hear or Applause) for the Windows client. (not the Web browser)
Unfortunately for these meeting reactions there isn't a defined hotkey (contrary to Raise your Hand)
I present here a solution implemented in the Teams Shortcuts PowerTool that provides shortcuts for these live meeting reactions.

March 8, 2021

AutoHotkey: Modal InputBox

I have struggled to set an InputBox in AutoHotkey as modal/ always on top. Unfortunately, there is no built-in option for this. I share here my learning and final solution.

How to manage Contact Favorites in Microsoft Teams

In Microsoft Teams you can organize your Contacts a bit in a flat structure. But still, it takes quite a few clicks to call or chat with a favorite contact. Wouldn't it be cool if you could do such from a launcher bar? I present here a solution for it.
Teams: Call favorite

March 5, 2021

Manage Favorites/Bookmarks for Microsoft Teams (Teams or Channels)

In Microsoft Teams you may get easily lost or it may take quite some time to find quickly a Team or dedicated Channel. Of course, you can sort your Teams, hide and you can also search. But still wouldn't it be nice if you could manage Teams and Channels like you manage Bookmarks or Favorites and quickly search for them from a Launcher bar? I present here such a way using the Teams Shortcuts PowerTool.

March 4, 2021

New Teamsy Standalone Launcher for Microsoft Teams

I have added a new member in the Microsoft Teams PowerTool family, I call Teamsy Launcher. In short, it offers the Teamsy functionality without the need of an external application launcher.
It is also included in the Teams Shortcuts PowerTool.
I highlight here this new feature.

February 26, 2021

Shortcuts to mute an App e.g. Microsoft Teams incl. Audio Devices/ Speaker

In some cases it might be useful to mute Microsoft Teams audio coming from a meeting. Not only your microphone but also the speaker, input audio. For example you only want to watch the screen sharing till an interesting point is coming but still hear music with your headset. Or want to mute the meeting music during breaks.
Unfortunately there isn't a hotkey / shortcut for this in the Teams Desktop Client.
I present here a shortcut to do this.

How to Get Microsoft Teams Push To Talk Functionality

How to use Push To Talk (PTT) feature with Microsoft Teams Windows Desktop Client and the Teams Shortcuts PowerTool (based on AutoHotkey)

February 23, 2021

Microsoft Teams: Shortcut to Raise your Hand

Finally, a hotkey is now available in Microsoft Teams to raise your hand in a Teams meeting.
I highlight here how it works and how to empower this hotkey using Teams PowerTools: Teams Shortcuts and Teamsy. (change it, make it global, run from launcher)

February 17, 2021

LastPass to Bitwarden (Password manager transition)

LastPass will change its free plan (on March 16 2021) so you won't be able to use it both on mobile and PC.
This is the kick for me to switch to another Password Manager. (LastPass also got some critical security issues in the past). I have chosen as alternative Password manager Bitwarden, because it is open source and free and well recommended and meets my basic needs (browser extension+mobile access to vault).

February 8, 2021

AutoHotkey Pitfall: System Tray actions remove window focus

I have again stumbled upon this tricky behavior in AutoHotkey: when clicking on a script tray icon the focus of the active window will be removed.

Quick Create Gist (AutoHotkey script)

Recently I have learned from Joe Glines aka the-Automator this nice way to quickly create a Gist with AutoHotkey. I share here my improved solution/ workflow.

February 5, 2021

Reinventing Organizations (Book recommendation)

I have just finished recently reading Reinventing Organizations by Frederic Laloux
And I highly recommend it.


Next, I will have a look at the Videos Collection

All this is provided for free - Pay What you Feel Like

So don't hesitate to try it! 


Thanks to Harald Schirmer for recommending this within Continental.

After reading it, I have reflected a bit upon the stage of my current company.

At the beginning I had some troubles to understand the term "Teal organization". (I am not an English speaker) but Teal is just a color like blue-green.

Teams Shortcuts PowerTool: New features: Icon Tray Click actions to toggle mute and video and Global Hotkey to Toggle mute

I present here in this post the last features implemented in the Teams Shortcuts PowerTool end of January 2021.

AutoHotkey: How to add a Setting for a user-configurable hotkey

In this post I explain how you can offer the option to your user to set a custom hotkey for your AutoHotkey script. This option is configurable via a AHK Icon Tray Settings menu.
I illustrate this on a example, the Mute PowerTool.

February 1, 2021

AutoHotkey: Custom Tray Icon Clicks

Normally AuoHotkey Tray Icon only enables a context menu that you can reach out via right-mouse click on the icon. I explain in this post how you can customize different click actions on the Script tray icon - for example add a left-mouse click action and another for right-mouse click.

AutoHotkey: Embed image in Script / Toggle Tray icon

In AutoHotkey, you can embed an image into a Script. I've been using this for example to be able to switch a script tray icon (see mute on/off) and still provide the script as single file, without any image files dependency.I explain here in this post how to do so.

January 26, 2021

Microsoft Teams: Clear cache

Sometimes the Microsoft Teams Client is stuck and needs a fresh restart. I explain in this post how to clear the cache manually and with the PowerTools Teamsy and Teams Shortcuts.

January 25, 2021

PowerToys - Great Windows 10 Utilities

PowerToys are great Windows Utilities provided by Microsoft and Open Source.
I share here resources and my key take-aways about them.

January 21, 2021

Chrome New version 88

There is a new version 88 available for Chrome. 
I share here my main take-aways about the new version.

CLC Jahresmotto 2021

From the Corporate Learning Community https://colearn.de/clc-jahresmotto-besser-formulieren-wissen-teilen-ist-macht/

Current Motto: Von „Wissen ist Macht“ zu „Wissen teilen ist Macht“
What do you think about it? Alternative formulations?

January 18, 2021

Chrome Customization: Ctlr+Tab to switch to last Tab

I was struggling to switch between two Tabs in Chrome, having opened many.
I share here my final solution.

January 15, 2021

Connections Excel Tool Presentation

This post is a placeholder for a potential presentation. 
It was submitted to DNUG Connections German User Group https://dnug.de/call-for-abstracts/

How to add a counter/timer?

We got this question within Continental: How to add a counter in a Connections page?
I share here the solution/ answer to it.

YouTube Channel displaying Subscribed Channels

In my YouTube Channel I had the problem that on the Channel Homepage under the Channels Tab, all my subscribed channels were displayed.
I struggled quite a lot to fix it. I share here how I've changed this.

January 14, 2021

Teams Custom Backgrounds

In Microsoft Teams you can upload a custom background image for your meetings via the Client Interface. I share here a tip how to add custom backgroung images on your Windows PC via the File Explorer.

January 4, 2021

Custom Search Engines triggered by CapsLock modified hotkeys

With AutoHotkey it is pretty easy to add hotkeys to run a special search engine on the current text selection.
Moreover you can remap the else useless CapsLock key for this purpose.
I present here how it can be implemented and is implemented in the NWS PowerTool.

December 15, 2020

How to open Teams link directly in the client desktop app?

In this post I explain a trick how to open Microsoft Teams links directly in the Desktop Fat client without going through the browser.

December 11, 2020

Send to Kindle

As explained in a previous post I am used to ordering Kindle ebooks on Amazon.com and send them to my Amazon.de Kindle. In the past, I was doing so by forwarding the order email to my Kindle email with the .mobi file attached.
Now Google Mail does not allow me to send bigger Email attachments. So I had to look for another way.

Blogger: Analytics issue because of mobile views

I've noticed following trouble with Blogger and Google Analytics:
A same page will have different analytics wether it is opened from mobile or not.
I present here a solution to fix this.

December 10, 2020

Microsoft Teams: New Breakout Rooms feature

Microsoft Teams has just released this new Break-out rooms feature. I share here good references and tutorial about it.

Open multiple Microsoft Teams instances

I share here a trick how to open a second instance of the Microsoft Teams client.
I personally prefer to open Teams in the browser for this but one of you might be interested in it.

December 8, 2020

Video Tools

I list here some video tools recommendations/ resources for creating video content on a Windows PC.

December 7, 2020

Monitor web content

Frequently I want to watch a webpage i.e. be notified when a web page is updated.
Common use cases for example: get a notification when a software is updated (watch the changelog), be notified when a question (I haven't asked myself but I'm interested in its answer) in StackOverflow is updated, dedicatedly watch a page in HCL Connections (out of my overcluttered notifications feed), subscribe to a github commit feed etc.

I present here the best solutions I have found so far for this.

James Clear: sharing, writing, recording, networking

I have listened recently to this podcast with James Clear (Atomic Habits) interviewed by Chase Jarvis (CreativeLive).
Below are some notes/ transcripts that resonated with myself related to a digital role model mindset: networking, why writing, sharing and recording.

Chromy: Chrome Launcher Plugin

In this post I share a Chrome Plugin for a Launcher e.g. Executor (my preferred one) or Launchy.
(It is implemented in AutoHotkey but shared as small executable.)

December 3, 2020

Read faster

I summarize here some techniques/ resources I have learned about Speedreading/ how to read faster.

Mindfulness recommendations

I share in this post some recommendations related to mindfulness.

Get Microsoft Teams Team name and link from file url

Using the NWS PowerTool (implemented with AutoHotkey), when you intellipaste a link to a file located in a Microsoft Teams SharePoint, before the link a nice link to the Team can be displayed.
Example:  Knowledge Brokers TeamGeneral > Knowledge Broker Toolkit > Overall Introduction_Knowledge Brokers.pptx (part highlighted is a link to the Team behind the file)
I explain here how this feature works.

How to get the file link from a SharePoint/OneDrive Sync location

This is a technical post highlighting some implementation part in the NWS PowerTool.
This explains how to get the URL to a file in a SharePoint Online or OneDrive from its local synced location.

November 23, 2020

Teams Shortcuts: Smart Reply

In this post I highlight a feature implemented in the Teams Shortcuts PowerTool.
This is about how to reply to a chat thread in Microsoft Teams quoting the selected previous thread in a nice quote block with mention to the quoted thread author and a link to the quoted conversation - all this within the stroke of a hotkey. I call this feature "smart reply".

Teaser animated image:
Microsoft Teams Smart Reply with mention and link to conversation


November 18, 2020

Outlook Shortcuts: Personalize Mentions

Like for Microsoft Teams with Teams Shortcuts, you can personalize mentions in Outlook using the Outlook Shortcuts PowerTool.

November 17, 2020

Teams Shortcuts: Personalize Mentions

Mentions in Microsoft Teams are not very personalized. (This does not fit to a #callmebymyfirstname #gernperdu culture.)

In this post I explain how to personalize Microsoft Teams mentions the manual way and the powerful way using Teams Shortcuts Powertool. (AutoHotkey can "du" it)

November 12, 2020

RegEx Greedy Trap

I have stumbled upon a regular expression trap - so called greedy (or ungreedy) trap. In short, in regex the ungreedy operator does not mean the shortest possible match
I explain here the problem description where I have faced it and workaround I came to use.

November 10, 2020

CamGif: Great small free tool to create gifs

I recommend CamGif to create animated images aka Gif files on Windows.
It is free, very light (700kB), portable (it is only one exe file), maintained (last update as of now Nov 2020 was in Oct. 2019), which creates small size output file and provide also edit capabilities.

October 31, 2020

Cursor Highlighter

I've stumbled by chance (watching Kevin Stratvert's great videos) on this great tool provided by Prof. Luc Boisvert that allows you to highlight your mouse cursor. It is really handy when you are presenting or recording screencasts.
I have included it in my PowerTools so you can start, install run from the PowerTools bundler and also
I provide it as a compiled version: that will avoid you to install AutoHotkey (prerequisite you trust me)

October 27, 2020

Global Hotkey Launcher

Most of the PC applicaitons provide hotkeys but they can only be accessed if the program window is activated. (no global hotkey)
Moreover hotkeys are sometimes hard to remember.
I present here an approach using AutoHotkey and a launcher app to easily launch program-specific features even when the program is not activated and using an easy to remember keyword syntax.
I illustrate this approach for Microsoft Teams and Microsoft Outlook.

October 14, 2020

Jira Export Excel Tool

If you want to export a Jira Filter to Excel or csv, you will face the 1000 issues limit so that the built-in export does not work.
I present here a nice Excel/VBA-based tool that make Jira filter export to Excel a one-click solution.

Blogger: share to twitter including post preview with pictures

 I was looking for a way while sharing one of my Blogger blog post to twitter to embed some nice blog preview including images.

I have this solution here: https://www.kimsixbloggersupport.com/2016/04/how-to-add-twitter-cards-to-your.html 

Blogger: Hide Post Footer from Home

While adding the last modified date to my Blogger blog posts footer, this date isn't displayed nicely in the Home / list view.
I have looked for a way to hide the footer from this index view only.
This is the solution I have found.

Blogger: Add Last Updated / Modified Date

I was looking for a way how to display the Last modified date besides the first published date in my Blogger blog.

I have found the solution here: https://www.twistblogg.com/blog/last-updated-date-in-blogger 

October 13, 2020

How to hide Blog description from Blogger Template

It is recommended for SEO to add a Blog description.

But the default blogger Template will then display it below the Home page title.


This clutters a lot the page and it isn't very useful/ a bit annoying. Specially if you already have an About page. I present here how to hide the blog description from you Blogger theme.

AutoHotkey: Gui to list and select a window

For getting the current Teams window, I have looked for a GUI Utility in AutoHotkey to select a window from a list.
I present here my final solution and code for this.

October 8, 2020

Excel Trick: Average/Formula for visible range only TLDR; SUBTOTAL(10x,

Today I have learned this trick in Microsoft Excel:
How to calculate an average for a range but for only the visible cells? (e.g. if you hide some rows or use a filter in a Table.)

Chrome Extension: View source

This is a recurring question I always have to look out: How to view the source code of a Chrome Extension?

I document here the step-by-step answer.

October 6, 2020

Blogger: Embed GitHub file

I have looked for an answer to this question: How to embed a GitHub file in a Blogger blog post?

Microsoft Teams: Better New conversation

Microsoft Teams client for Windows got an update with this new "New conversation" button.
This is great but unfortunately, the hotkey for creating a new conversation with the box expanded (Ctrl+Shift+X) isn't working anymore.
I present here a workaround I have found that is implemented in the Teamsy and Teams Shortcuts PowerTools.

Jira to Power BI (Recursive approach)

It is not so obvious to get data from Atlassian Jira into Microsoft Power BI. I share here my learnings and solution about it.
Update: see improved version

October 1, 2020

How to get Microsoft Teams main or meeting window? (Empower Teams Shortcuts with AutoHotkey)

Microsoft Teams provides hotkeys but they are only running if the target window is active. That means for example there is no "universal" hotkey to mute yourself during a meeting: you have to have the meeting window active to run it.
For running universal Teams Shortcuts from an application launcher see Teamsy or a small utility like the People Connector it would be great to have an efficient way to activate the Teams main Window or the active Teams Meeting window.
I present here my current solution - implemented in AutoHotkey.

September 18, 2020

Quick Share a link to Microsoft Teams

Introduction
I have discovered recently by chance this nice feature: https://docs.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/share-to-teams that allows to quickly share a link from the browser into a Microsoft Teams Channel.
I share here my learnings and how to integrate this feature e.g. to a hotkey.

September 16, 2020

Outlook VBA: How to get Appointment Organizer or Email Sender Email

I have struggled to find out this one: How to get an Microsoft Outlook Appointment Organizer in VBA.

I needed this for this nice Outlook to Teams Chat Macro.
I share here my learning and final solution.

How to create a shortcut to/ start an office 365 Standalone Web Application?

Introduction

Most of the office 365 applications can be accessed via the browser. You can browse to them via the waffle = open office.com.
Now for each application if you use Chrome as browser you can also create a shortcut to the web apps a bit less cluttered by the default browser menus and toolbar.

I explain here step-by-step how to do this.

September 11, 2020

Outlook to Teams Group Chat (VBA)

The integration between Microsoft Outlook and Microsoft Teams has still room for improvement.
(Right now you can forward and email to a channel using the channel email and share a conversation from Teams by email)
The nice Reply with IM only opens a chat with the From recipient. (1-1 chat) and with Reply All with IM it replies to all Recipients in To AND Cc. Also the name of the chat does not reflect the outlook item subject (contrary to Skype IM integration)
A common use case is from an Email or a Meeting you want to generate a Group Chat with the same list of recipients.
I present here a workaround based on VBA.

This post is a Work-In-Progress and will be continuously improved based on the interest/ comments.

Open Teams Links directly in the App

When opening Microsoft Teams Links (starting with https://teams.microsoft.com) before being redirected to the Microsoft Teams App/ Client then will be opened in the browser and you might get a left-over window opened in the browser.
I present here a way to workaround this issue.

September 10, 2020

Universal Date Picker/Calendar with week numbers/ Quick insert current date

(AutoHotkey is really great!)
With AutoHotkey you can very easily get a date picker + small calendar utility displaying also the week numbers.

(This might avoid you implementing forms in vba.)

Microsoft Teams: Multiple Windows

Microsoft Teams keeps making improvements but it isn't still close handling multiple windows as you would expect in state-of-the-art tools (even Skype was better). Pop out chat came recently and also Separate Meeting Windows with the New Meeting Experience.
Still, one common pain/ wish is to be able to monitor the meeting chat on another screen/ window while attending the meeting or even presenting in a meeting. Or view the attendees' video while presenting.

As common workaround for this, I use the trick to open Teams in the browser. (Another workaround to open a second client instance is explained in this other post.)

September 7, 2020

Teams link to 1-1 chat or call

It is sometimes nice to provide a link to a team chat or call example in your email signature to drive Microsoft Teams adoption and for quick reach out from your colleagues.
I explain in this post how to create/ use such links.

How to synchronize playlists between services (Spotify, Google Play Music...)?

For running, I was used to using Google Play Music to hear music offline from my phone.
Now Play Music will soon be closed and YouTube Music does not offer offline listening for free.
So I had to look for a way to synchronize my Google Music Playlist to another service like Spotify.
(With Spotify Premium you can download a playlist to your phone and here music offline, without internet connection - even if this account is used by someone else e.g. in your family)

I share here the solution I have found.

How to synchronize MiFit workouts to Strava?

I am using a MiFit Band 4 for activity/ workout tracking (combined with my Android phone).
I was looking for a solution to synchronize activity/workouts to other services like Strava. 
I share here the solution I have found.

August 4, 2020

AutoHotkey: Adaptive ListBox

In AutoHotkey I was looking for displaying in a ListBox Gui several text options with the width of the listbox being adaptive to the length of each options. See illustration below:


I couldn't find a standard solution for this but I have found two resources in the AutoHotkey forums which I have combined to build a library function.

Executor: My preferred App Launcher

I have been using Launchy since years.
Now Launchy is unfortunately not maintained anymore - since 2008 and its follower LaunchyQT lacks some features I was used to.

So I have looked for an alternative and came to use now Executor.
I present here a short overview how I use it.

August 3, 2020

Outlook Google Calendar Sync

It is sometimes pretty useful to be able to view his work calendar within your private mobile phone.
In private I use Google Calendar where I also share my calendar with my close family members.

To synchronize my work calendar to my Google Calendar I use this small utility:
@OGCalSync
Source code is available in GitHub here: https://github.com/phw198/OutlookGoogleCalendarSync/

I set it to synchronize to a separate Calendar 'Work' also to a separate Google account dedicated for Work purpose.

Be aware not to share work critical information with Google. 

Blogger: How to remove date from url

I was annoyed about standard blogger post url with a date in it e.g. https://tdalon.blogspot.com/2020/07/teamsy.html . I wanted a date neutral one so I can redirect documentation with a fixed doc root url (example from internal to external). Instead of previous url https://tdalon.blogspot.com/2020/07/teamsy.html something like this: https://tdalon.blogspot.com/teamsy  This is a solution I have found to fix it.

Blogger: How to add a Table of Contents

I have been looking for a way to insert a table of contents to my blogger blog posts that is built automatically.
This is the solution I have found.


Thanks to MyBloggerTricks (MBT) for sharing this one.
 

Blogger: How to add Excerpts

I was looking for this one for my blogger blog: How to display in the Blog Homepage not the full blog posts but only a preview/excerpt of the posts with a Read more link?

I have found the answer here:
http://blogaholicdesigns.com/tutorials/how-to-add-post-excerpts-on-blogger/

It is very easy (it has changed a bit with blogger update)
Simply add a page break now called insert jump break where you want the excerpt to end.

How to create a shortcut to an app from the Microsoft App Store?

For starting a program from the Microsoft App Store (e.g. MS Whitboard or MS To-Do) from an application launcher like Executor or Launchy I was looking for a way to create a shortcut to such an app.
This isn't trivial as expected. Here is the solution I have found.

July 28, 2020

Teamsy: Launcher Plugin and Commander for Microsoft Teams

I present here how to master Microsoft Teams hotkeys and shortcuts from your preferred application launcher (e.g. Executor or Launchy) or from the command line e.g. with StreamDeck - using a small but very powerful tool implemented with AutoHotkey. I call it Teamsy.

Update: these feature are also available without requiring an external application launcher. See New Teamsy Standalone Launcher for Microsoft Teams

July 27, 2020

AutoHotkey: Read a CSV Table

Having exported a list of my Teams into a CSV file (see previous post) I want to be able to read this table.
The CSV file looks like: first row is for the header. Then each following row contains information for each item in the list.
Properties of each item are ordered column-wise.
I want given a value for one property to get the value for another property.
Example: 
TeamName := ReadCsv(CsvFile,"MailNickName",MailNickName,"DisplayName")

July 14, 2020

MS Outlook: Edit Received Emails

In this post I share a quite unknown Microsoft Outlook tip.

I want to be able to edit received emails to better search them later.
I receive a lot of emails with unclear subjects for example. (who doesn't?).
I don't want to have to forward it to me to be able to edit the subject of the email because the sender is then changed to myself and it duplicates the email.

July 3, 2020

Bookmarklet: Open Amazon book in Goodreads

Introduction I like before buying a book on Amazon to check the reviews on Goodreads. You can use a bookmarklet to do this in one click.

Goodreads offers one but it doesn't work. https://www.goodreads.com/user/edit?tab=widgets
Here is a working solution.
 

Good solution in Github

See https://gist.github.com/lightningdb/cfee260c3b7af7e65fce

javascript: var asin_elements, asin;asin_elements = document.getElementsByName('ASIN'); if (asin_elements.length == 0) { asin_elements = document.getElementsByName('ASIN.0'); };if (asin_elements.length == 0) { alert('Sorry, this doesn\'t appear to be an Amazon book page.'); }else { asin = asin_elements[0].value; if (asin.match(/\D/) === null) { var x = window.open('http://www.goodreads.com/review/isbn/'+ asin, 'add_review'); } else { var x = window.open('https://www.goodreads.com/search?q='+ asin); } x.focus();}

My solution

My solution used some regexp trick:

javascript: var array = document.URL.match(/amazon\..*?\/.*?\/([^\/\?]*)/); if (array == null) { alert('Sorry, this doesn\'t appear to be an Amazon book page.'); } else { var x = window.open('https://www.goodreads.com/search?q='+ array[1] + '&search_type=books'); x.focus(); }

Installation

Add a bookmark and paste the code in the URL



Chrome Extension: Close Current Tab

Introduction I've faced the challenge in a Chrome extension to close the current tab - and the chrome window if this Tab is the last one.

Standard answer

chrome.tabs.query({"active": true, "lastFocusedWindow": true}, function (tabs) {
chrome.tabs.remove(tabs[0]);
});
The drawback of this solution is that it won't close the Chrome window if it is the last tab to be closed.

My solution (close window if last tab)

/ ----------------------------------------------------------------------------------------------------------
function closeCurrentTab(){
// Close current tab and browser window if last tab
// chrome.tabs.remove will not close the window on last tab closure -> needs to check if single tab opened
chrome.tabs.query({
    //active: true,
    currentWindow: true
}, function(tabs)   {
    if (tabs.length > 1{
        chrome.tabs.query({
            active: true,
            currentWindow: true
        }, function(tabs)   {
        chrome.tabs.remove(tabs[0].id, function() { });
        });
    } else {
        chrome.windows.getCurrent(function(win) {
            chrome.windows.remove(win.id, function() { });
        });
    }       
});

AutoHotkey: Customize Button Message Box

It is not so easy in AutoHotkey to use a custom Message Box with customized Text on the Buttons or as many buttons as wished.
I present here 2 approaches and share some code.

June 15, 2020

AutoHotkey: TrayTipAutoHide

There is a nice function in AutoHotkey to display system tray notifications called TrayTip.
I present here an adaption to display the notification and auto-hide after a customizable time.
(The 3rd input parameter 'Time' in the active TrayTip function has no effect on Windows Vista and later.)

March 9, 2020

Text Expander supporting links / rich text format

Text Expander functionality is really useful. I have used PhraseExpress on Windows for this a lot (free for personal use only).
Now you can also use AutoHotkey for this using the so-called Hotstrings.
I present here a way to use Hotstrings that support links i.e. rich-text formatting.
It is based on the AutoHotkey utility I have highlighted in a previous post: WinClip

February 20, 2020

AutoHotkey: Copy content of MsgBox

While debugging in AutoHotkey I use a lot of MsgBox.
I've used also to copying to the clipboard (clipboard:= sVar)
to search and have a look in a variable content
Because I could not find a wait to copy the content of the MsgBox.
You can not select the content of the MsgBox.

The point is: you can ; just by pressing Ctrl+C: it will copy the whole content of the MsgBox. (plus the window title)

See here where I've found this answer in the AutoHotkey forum.

February 13, 2020

AutoHotkey: Add option to launch on startup

It is common to want to add your AutoHotkey script to the startup, so that it automatically is started when you start your PC.
I share here a standard approach to provide this to the user.

February 12, 2020

AutoHotkey: Clipboard handling

For clipboard handling with AutoHotkey I recommend the following resource called WinClip .

February 10, 2020

AutoHotkey: Undocumented Hotkeys for Gui Menus

This is a feature a bit hidden/undocumented in AutoHotkey I have learned from Jack's blog post here:
https://jacksautohotkeyblog.wordpress.com/2019/12/30/use-autohotkey-gui-menu-bar-for-instant-hotkeys/

When appended to the end of a MenuItemName, the tab character (`t) followed by one or more standard Hotkey modifiers (CtrlAlt, or Shift) plus another key “indicates a keyboard shortcut that the user may press instead of selecting the menu item. If the shortcut uses only the standard modifier key names CtrlAlt and Shift, it is automatically registered as a keyboard accelerator for the GUI.”
I use this for example in a simple ListView Gui with checkboxes to be able to select all with Ctrl+A.

Menu, ItemsMenu, Add, Check All`tCtrl+A, SelectAll
Menu, ItemsMenu, Add, Uncheck all`tCtrl+Shift+A, UncheckAll

SelectAll:
LV_Modify(0, "Check")  ; Uncheck all the checkboxes.
return
UncheckAll:
LV_Modify(0, "-Check")  ; Uncheck all the checkboxes.
return

This saves a lot of work-arounding with dynamic hotkeys.

(Thanks to Jack for sharing it)

January 20, 2020

PowerPoint: Change Language in whole Presentation (VBA Macro)

Working in an international environment, I need a lot of time to fix the language in a whole PowerPoint presentation. There is no built-in feature for this available. I share here my VBA based solution.

January 13, 2020

Gmail Disposable Email Addresses

This is a (old but still) great tip to know if you are using Gmail / Google Mail:

You can use custom email addresses postponing a +text to your standard gmail adress before the @.
Example: I can use thierry.dalon+spam@gmail.com

LinkedIn Translation Language Settings


Are you annoyed in LinkedIn by this "See translation" button for posts you understand the language of?


You can add additional languages you understand to avoid this.
Go to Settings->Account->Site preferences->Content Languages