As Microsoft pushes Excel towards Power Platform and JavaScript Add-ins (Office Add-ins), classic VBA-based tools like Suresh Addins are at a crossroads. However, because VBA is deeply embedded in enterprise workflows, it is unlikely to disappear. The developer community around "Suresh" is moving towards a hybrid model: maintaining the legacy VBA version for offline use while releasing a web-based version for Excel Online.
Once you clarify, I’ll write a complete, detailed post for you — including features, installation steps, use cases, and troubleshooting where relevant.
Just reply with more details, and I’ll get it ready.
To expand on the capabilities of Suresh Addins, a popular Excel tool primarily used for Indian currency conversions, you can develop features that modernise its core functionality and improve user workflow. Feature: Smart Currency Localisation
Enhance the existing =RSWORDS() and =INR() functions by adding support for modern regional requirements and automated formatting.
Dynamic Language Support: Expand =RSWORDS(cell, "language") to allow users to output amounts in various Indian languages (e.g., Hindi, Tamil, Bengali) instead of just English.
Automatic Symbol Formatting: A feature that automatically applies the ₹ Rupee symbol to any cell processed by a Suresh Addin function, saving the manual step of using shortcuts like Ctrl + Alt + 4.
GST & Tax Calculation Integration: Add a function like =INR_GST(amount, rate) that calculates the tax and provides the "Total in Words" (including GST) in a single step, which is highly useful for invoice generation. Feature: Modern Integration & Accessibility suresh addins
Since the original add-in often requires manual installation via the "Tools > Add-ins" menu, modernising the delivery can improve the user experience.
Custom Ribbon Tab: Develop a dedicated "Suresh Tools" tab on the Excel Ribbon. Instead of typing formulas manually, users could click a button to "Convert Selection to Words" or "Toggle Currency Format."
Office Add-in Compatibility: Transition the legacy .xla format to a modern web-based Office Add-in (JavaScript/TypeScript). This would allow the tool to work on Excel Online and Mac, accessible through the Microsoft Store/Get Add-ins menu.
Bulk Conversion Tool: A "One-Click" feature to scan a selected range and convert all numbers to words in an adjacent column, improving speed over the standard Auto Fill method.
Fill data automatically in worksheet cells - Microsoft Support
To truly master this tool, follow these power-user tips:
A common question is: "Why use Suresh Addins when I have Power Query or I can write VBA?" Here is a quick comparison: As Microsoft pushes Excel towards Power Platform and
| Feature | Suresh Addins | Power Query | VBA Scripts | | :--- | :--- | :--- | :--- | | Learning Curve | Very Low (Click & Go) | Medium (Query steps) | High (Programming) | | Speed for Small Tasks | Instant | Slow to load | Instant (after run) | | One-off Tasks | Excellent | Overkill | Poor (needs coding) | | Customization | Low (Pre-set buttons) | Medium | Unlimited | | File Folding | Yes | No | Yes (complex) |
Verdict: If you need to clean messy data quickly without learning a new language, Suresh Addins wins every time.
One of the most searched features is the Split Workbook tool. Imagine you have a master Excel file containing sales data for 50 different states. You need to send individual state-wise reports to 50 different managers.
The default Excel interface is powerful, but it often requires multiple steps to perform common tasks. For example, to unmerge cells and fill down blank values, a normal user would need to use "Go To Special" > "Blanks" > type a formula > press Ctrl+Enter. With Suresh Addins, it is a one-click operation.
Here are the top reasons why professionals are adding Suresh to their workflow:
Getting started with Suresh Addins is straightforward. While there are different versions floating around (Free Lite vs. Paid Pro), the general installation process remains the same:
Step 1: Download the file.
Ensure you download the .xlam (Excel Add-in) file from a trusted source. Caution: Always scan for macros viruses before enabling. To truly master this tool, follow these power-user
Step 2: Open Excel and navigate to Options.
Step 3: Manage Add-ins.
Step 4: Browse and add.
Step 5: Enable the Ribbon.
You should now see a new tab in your Excel ribbon. If the add-in is not visible, you may need to adjust your Trust Center settings to enable all macros (or digitally sign the add-in).
Pros:
Cons: