Tags » Vba

Función Vba Excel para encontrar parte de un texto dentro de otro.

Días atrás me llegó una consulta del siguiente tipo: Una persona recibía de una tienda productos que se habían vendido pero sólo le entregaban los 4 últimos números del código de barras. 251 more words

Vba Excel

Freematics Data Importer V1.1

I noticed that Freematics changed their data format structure so this will now account for either the old or new data structure and labels.  Also fixed a bug where the data would not import if there were no speed values in the file. 72 more words


Versatile Blogger Award 2017.

Thanks a bunch @StyleMyMind for kick-starting my day with a nomination for The Versatile Blogger Award. It came as a thrilling surprise because I never knew about this until few hours ago. 367 more words

Building switch formula in Excel

Below is the vba script for creating switch-equivalent formula in excel. Criteria refers to the number of cases and the output will be the result regarding different cases. 146 more words


Create a GUI in AHK is very simple. Here is an example of a GUI named “Text AHK“, 250px wide, with 4 labels… 65 more words


New year's resolutions that last (and really help!)

This post was written by VBA

New year- new me?

January is always full of ‘New Year New Me’ mantras – I feel quite overwhelmed already by the pressure to make 2017 ‘unforgettable’ or to overhaul a particular aspect of my life.  1,333 more words

Teaching And Learning