A spreadsheet application, designed by Microsoft, Ms-Excel is one of the most popular applications with features like pivot tables, graph, and calculations. It also supports a macro programming language called VBA (Visual Basic for Applications).
I have previously shared an article in which I have explained how to use the VBA FileSystemObject to work with local files and folders from your Excel worksheet. Now, let’s see how using the methods ...
The FileSystemObject (or FSO) in VBA, provides methods and properties, which allows programmers to access and manipulate files in their computer. You can do a host of operations related to files and ...
A File dialog box allows you to choose one or more files from a folder in your computer. You can open a file dialog box from your Excel worksheet using VBA. Microsoft Excel’s “.FileDialog” method of ...
You can dynamically change column width or the row height in your Excel worksheet using simple properties in VBA. It becomes necessary when you have texts or data in columns that either hides or over ...
I have previously shared an article with an example showing how to open a word document from excel and copy excel data, a table, to the word doc using VBA. You can reverse the process, that is ...
It is very easy to add text to shapes dynamically in Excel using VBA, provided you know the properties. VBA’s “Shape” object provides a property called “TextFrame”, which gives access to the text of ...
You can insert different kinds of shapes in your Excel worksheet, like a circle or a rectangle etc. These shapes can be used for various purposes and you can easily change its properties like ...
You can use WinForms DataGridView control for doing CRUD operations. Your data source can be anything like an SQL Server database, JSON or Ms-Excel. Here in this post I am sharing a small program in ...
Ms-Excel is still one of the most popular applications used all over the world by enterprises, big and small. Using Excel, you can now maintain complex data structures, create graphs and more. You can ...
You can easily modify data in an Excel file from your Windows Forms, popularly known as WinForms. In fact, you can do many things like read, edit and add data to your Excel file from WinForms. Here ...
