May 2, 2019 | Access, Excel, Office Automation, Outlook, PowerPoint, VBA, Word
Gmail, the world most popular email service developed by Google. Today just about almost everyone owns a Gmail account. We know it is pretty easy to create a VBA script in Microsoft Excel to integrate with Microsoft Outlook, from there, we can send an Outlook email,...
Apr 30, 2019 | Excel, VBA
Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to...
Apr 29, 2019 | Excel, VBA
Quiet often when you collaborate with a team member or group of people on a Excel spreadsheet, when the most commonly thing is people will apply strikethrough to the items or texts they want to remove from the file. Not sure why in Excel, there is no function to...
Apr 26, 2019 | Excel, Excel General
When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc). In this...
Apr 24, 2019 | Excel, VBA
Protecting a single worksheet is pretty easy, you simply hover your mouse, right click, and select Protect Sheet. But what happens if you are working on a Excel workbook that has like 50 worksheets and you want to password protect just certain worksheets?In this...
Apr 19, 2019 | Excel, VBA
When you work with Excel files that contain macros, ActiveX Control, userforms, or connect to an external data source, sometimes, you will get those annoying Privacy Warning message “Be careful! Parts of your document may include personal information that...
