Excel VBA: Get local path of file in OneDrive Sync location

I share here an issue you might encounter when using macros with sync'ed files from OneDrive, SharePoint.

Outlook blocks Meeting Copy

I share here some solutions to workaround Outlook blocking copying meetings or how to duplicate a meeting.

Jira Excel VBA Module with Basic functions

I share in this post some examples how to use Jira REST API from Excel VBA. This post is a WIP/Draft. If you are interested in me explaining more, leave a comment.

Jira: Add multiple links using R4J Excel Add-In and VBA macro

I share in this post a way to add multiple links to Jira issues using R4J Excel Add-In and additional VBA macros. This post is a DRAFT/WIP quick version. If you have questions about it, please leave a comment to let me know and I will update it.

How to automatically refresh Pivot Tables in Excel

I share a way to refresh Pivot Table automatically in Excel. Credit to Excel Campus

Outlook: Change meeting time if not organizer

Following scenario: I got a meeting invitation but the meeting took longer than the planned time e.g. 50min instead of 30min. I would like to update this meeting in my Outlook calendar to reflect the real time used for it.

Excel: How to concatenate Table column with delimiter - only visible cells

I have the recurring need to concatenate values in an Excel Table but especially only unfiltered visible cells. (One common use case of mine is to get a list of Jira Issue Keys to easily link to multiple issues)

I explain here to solutions I know and share a VBA macro to do this in one click. 

PowerPoint: Change Presentation or Selected Slides Language

I have updated my previous VBA based solution to change a language in PowerPoint: now you can change the language of the whole presentation or of selected slides only. In some cases you may have some slides in a different language e.g. English instead of presentation language in German.

MS Office Add-In How-To

I collect here some useful resources and tipp to work with Microsoft Office Add-In i.e. customize Office Ribbon.

Outlook: Automatically Mark Appointment As Private (VBA)

I would like when becoming an appointment sent from my personal Google Calendar or containing some keywords like the firstname of my children to have them marked in my work Outlook as private automatically.

I explain here how I have achieved this using some VBA code.

Outlook Trap: Get Real Email of Meeting Organizer (VBA)

I have stumbled upon a nontrivial use case for automatically handling items in Outlook VBA based on the Sender Email. This is when the item was sent "on behalf of".

Outlook: How to automatically categorize emails and meetings based on recipients/sender email domain (VBA)

I share in this post a very convenient way to automatically categorize your emails and appointments

(use case: highlight customer) based on some rules like the email domain used in the distribution list.

This is based on some VBA code.

Outlook: Never forget Meeting Reminders

In some cases in Microsoft Outlook, you might miss a meeting because no reminder was set. This can be quite annoying e.g. for a customer meeting.

Outlook: How to flag an email as complete with a hotkey

I like to use email flagging in Microsoft Outlook quite a lot and there I love to have a custom hotkey for handling it. I share how to achieve this: one implemented with AutoHotkey in the PowerTool Outlook Shortcuts and one implemented in VBA.

Excel: Copy Visible Cells only

I was looking for a way in Excel to copy the selection but only of the visible (not hidden) cells.

I share here my solution.

Excel VBA: Table to Json

I had to look for a possibility to convert a Table (aka ListObject) in Excel to a Json String in Excel VBA. I share here my findings and current solution.

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/

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.

Outlook: Move Email to secondary Tasks Calendar

In Microsoft Outlook, I like to use a secondary Calendar for planning my Tasks. This has the advantage not to block my main calendar by default (else you have to be careful to mark the appointment as Free) and have a clear split between Meetings and personal Tasks management.

I present here my way to "put" an email into my Tasks calendar in one click without duplicating content and with a real link from the Calendar entry to the original email.

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

I have struggled to find out this one: How to get a 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.