In my previous article on Excel automation using VBA, I have explained how to fill a web form and save the data, from Excel using VBA. The data that I have used in that example were hardcoded ...
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 ...
There are many ways you can run or execute a macro like, pressing the F5 key in VBA or simply clicking the run button. Or, you can insert a button (an ActiveX Control) on your Excel worksheet, click ...
Let us assume I have a word file with few paragraphs in it. I want to copy content as it is from the doc file and write it in my Excel worksheet, each word in a cell, go to the next line or row and ...
An alphanumeric value in an Excel cell may look like this “70 kg” (a number and two alphabets). Now, let us assume, I have two cells with values 70 kg and Rs. 50. How do I calculate these alphanumeric ...
Let us assume I have a UserForm in my Excel worksheet, which has few controls (or elements like textbox, label, checkbox etc.). How do I check if the control is a checkbox using a VBA macro? ...
Let us assume, I have sales data in my Excel worksheet for two or more consecutive years (for certain products), which I collect from different regions. I want to know the percent change in sales fig ...
In Excel, there is an in-built feature called the Subtotal (under the “Data” tab) which when used can automatically insert subtotals and grand total for a selected range of data. However, if you are ...
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 ...
In Excel, you can use the EXACT() function to compare two text strings, to check if the texts are similar or not. ...