You can use window.close() method to close the current browser tab/window in JavaScript. However, the method should be used with window.open() method. The .close() method will close a tab or ...
Web scraping is a process where an application extracts data or content from a web page. You can do this from an Excel worksheet using VBA. I have shared an article here before where I have explained ...
While working on worksheets using a macro, you may sometimes need to know if a particular worksheet exists in a workbook or not. Especially, when the worksheets have random names. You either ...
You can use the “transform” property in CSS to rotate an element. In this post I’ll show you how using the “transform” property you can actually rotate an image at a given angle. ...
We often pass data between web pages as information in the form of URL parameters (or query strings). A URL can have single or multiple parameters. When redirecting to another page from your ...
In JavaScript, you can use window.location.href or simply window.location property to redirect to another page. This is a quick JavaScript tip for beginners. ...
You can insert a variety of objects like Excel workbook, PDF or Word document, images etc., in your email message using Outlook (any version). You can automate this process. I’ll show you how you can ...
In this post here, I’ll show you how to get the selected value in a SELECT dropdown list using plain old JavaScript. This is for the beginners. ...
In SQL Server, you can use PIVOT to convert multiple rows into columns to show a summarized result. I’ll show how using this method you can easily save the rows to columns converted data into a table ...
Let us assume, I have two ranges of values in my Excel worksheet. Each range has two columns each (region and sales). Now, both the ranges have some common regions. How do you find the matching record ...