Skip to content
luiz maia

luiz maia

Digital Transformation & Program Management

  • Luiz MAIA
    • GitHub
    • Publications
    • Blog
    • Videos
  • red8.io
  • Contact
  • Apps
    • slotho
    • badmintho
    • formatho

Category: micromacros

How to import Polar workouts into Apple Health

What you will need: Your Polar data that you can get here. This Shortcut with the actions to import the … More

ios, json, shortcuts

How to load RunKeeper workouts into Apple Health using Shortcuts

What you will need: Your RunKeeper data that you can get here. Scriptable installed on your iPhone. Microsoft Excel. The … More

ios, json, scriptable, shortcuts

How to convert a CSV to JSON

I have recently started using the iOS’s Shortcuts and while trying to do more I have also started to use … More

charty, csv, ios, json, scriptable, shortcuts

How to create a custom ribbon for your Excel add-in

Ribbons are a customisable and simple way to have a more professional looking add-in

How to create a toolbar for your Excel add-in on installation

The good enough and the better way

installaddin

Getting the actual used range of a sheet

The ‘used range’ property can be really useful but it has known bugs

range, usedrange

Improving range browsing performance

Sometimes it’s necessary to browse through all of the cells in a sheet and using ranges can kill your code performance.

browse, range, variant

Make your macros shorter – IIf

Using “IIf” can make your macros shorter but be careful with code readability and maintenance

iif, iifvsif, inline

Posts navigation

Newer posts
  • Automating Portfolio Prioritisation Using Power Automate: Saving Time and Maximising Value
  • Formatho: Streamlining Azure DevOps Reporting with Native Apple Apps
  • Loggoo: Bridging the Gap Between Odoo and Issue Tracking Systems
  • AI-Powered CV Optimiser
  • How to automate text extraction from your screen
Proudly powered by WordPress
Theme: Rebalance by WordPress.com.