Microsoft Excel Posts
Word File as Ole Object
VBA Microsoft Word Microsoft ExcelI am sure that you know how to open a Word Document from Excel VBA and manipulate this Word document depending on the need within the Excel Workbook. The most basic way to open the Word document from Excel VBA is the code snap below... Continue Reading »
Last Row Number in VBA
VBA Last Row Microsoft ExcelWhen you try to write a Sub-Procedure, which needs to manipulate the data and the data doesn’t have a pre-defined number of rows, it is very important to find the appropriate way of discovering the last row number of the table you are working on. Or you might want to get 2 worksheets, which have the same layout ... Continue Reading »
Why VBA?
Automation VBA Microsoft ExcelOne of the most important skills at the moment is being an efficient user in Microsoft Excel. It is sure that most of people touched Excel from some point. Some tried to make small calculations, some tried to gather information about a specific topic. Excel is an... Continue Reading »