All posts by TCT
Use Frameworks To Avoid Fireworks: Introduction

Disclaimer: This is a watered-down approach of building frameworks. If you want a proper end to end article detailing each and every aspect of building a robust and dependable framework, go write one yourself. If you though this article was about implementing structural frameworks to avoid fire hazards… . . . Then don’t click away…
There’s VBA, Then There’s VBS.

I went off on a rant again, so if you want to get straight to the meat and potatoes, click here. VBA is pretty powerful, but today will explore something that isn’t nearly as powerful but just as useful. This might seem like a waste of time, but that’s because my ability to persuade others…
Using Macros Efficiently in Automation 360

Now that you are convinced of VBA’s potential and how useful they can be, it’s time we learned how to use them. This is important since running Macros is not as straightforward as running python or JavaScript. No scopes are provided within Automation Anywhere for VBA like it is for VBScript, Python or JavaScript in…
Configuration Files, and Why We Need Them

Ever heard of the method of Loci? It’s spelt with a “c”, not a “k”. Anyways, the method of Loci is a memory technique designed by a sixth century poet named Simonides. “Designed” might not be the right term for it, since he had more or less chanced upon it. Simonides was a poet, which…
RPA & VBA – Do They Mix?

While VBA is not the most powerful language out there, it is definitely worth learning but before I tell you why you should learn at least the basics, let’s address few misconceptions. “VBA is Outdated“ This is partially true, but that doesn’t automatically make VBA obsolete. Microsoft hasn’t issued a statement that they will stop…
Automate Incognito…But Why?

We’ve all used Chrome’s incognito mode for reasons I am not about to go into. So why do we do it? Let me rephrase that, why do we use incognito? What’s so special about it? Adding to What We Already Know It hides your activity online…well sort of, but yeah. Incognito doesn’t store the history,…
Leverage APIs with RPA

Are you sick and tired of performing manual and repetitive tasks every day? Hire a RPA developer and kiss your problems goodbye! Are you sick and tired of automating manual and repetitive tasks, only to retrofit those very same manual and repetitive tasks each time the application receives an update? Yes, I’m Sick of It…
DON’T Send These Mails: I Know I’m Late, But Here’s Why

Welcome to another installation of DON’T Send These Mails! Today, we will draft mails to our manager explaining why we showed up late to work. I mean we all make mistakes, don’t we? Our managers need to understand that we have responsibilities at home which we slack off on as well. I’m not sure what…
Pivot Tables Without the Pivot “Table” (Part-II)

If you haven’t read Part-I then I will come and haunt you in your dreams. . . . Now that we have our XML ready, we can mimic pivot table behavior with it. Well, Kinda. Pivot tables are easy to customize, whereas what I’m about to show you right now is not nearly as customizable…
Pivot Tables Without the “Pivot Table” (Part-I)

While Automation Anywhere is fantastic at Excel Automation, there are instances where it falls short but it’s not due to negligence. It isn’t practical to develop Actions or Commands for every conceivable operation, because maintaining that would be a nightmare, let along developing them which is why I believe it’s important for RPA Developers to…