Companies using Robotic Process Automation

List of Companies using Robotic Process Automation [With comparison] After publishing the Robotic Process Automation What Why How All You Need to Know [Vendors/Tools/Jobs/Checklist], I received requests from some of my readers to provide a comprehensive list of Companies using Robotic Process Automation. In this post I’m going to cover…

Continue reading

Robotic Process Automation Complete Overview [Tools,Vendors,Jobs etc.]

Robotic Process Automation (RPA) – All you need to Know What is Robotic Process Automation: I have been researching and reading about Robotic Process Automation since 2014. In this post I’m going to explain all my understanding and researches about RPA in a layman’s language. So that anybody who reads…

Continue reading

VBA Code to Change File Extension

Change File Extension using VBA Code (with Images) What is it: This VBA code will help you change file extension of the files in a particular folder/directory. For eg. If you want to change the extension of the Excel files received in .xlsx to .xls or visaversa then this VBA…

Continue reading

VBA Code to Close all Workbooks in One Go

VBA Code to close all workbooks all Workbooks in One Go What is it: This VBA Code will help you close all workbooks opened in the system in one go. Why: When you are creating an Excel Macro to create a consolidated report from multiple individual workbooks and after updating…

Continue reading

VBA Code to Open Excel File from Folder

Open Excel File from Folder with VBA Code What is it: This VBA Code will help you browse and Open Excel File from Folder or a directory. Why: When you create a program and if you want to provide the user an option to select a particular Excel file and…

Continue reading

VBA Code to Protect Worksheet with Password on Close

Password Protect Worksheet on Close with VBA (with Images) What is it: When you want others to only view the workbook data and no editing should be permitted then you have to make sure you protect the workbook with password while closing it. So that even if someone tries to…

Continue reading

VBA Code to Import Access Table /Query data to Excel

Import Access Table to Excel with VBA (Images and Code) What is it? This VBA code helps you to download or import Access Table data or Query to Excel in one click. Why is it? You can import Access table data to Excel without even opening the Access DB. How to import Access…

Continue reading