If you work with both Microsoft Word and Microsoft Excel, you may have noticed that Microsoft Word has a “change case” button in the Font section of the ribbon which allows you to quickly capitalize or lowercase sections of your document. While Excel does not come with such a button by default, it is possible to add buttons to set the case of the highlighted cells.
Continue reading “Add Change Case Buttons to the Microsoft Excel 365 Ribbon”Category: VBA
How to Use VBA To Run a Powershell Command and Get Return Value
If you need to interface with some sort of external command line program during your macro, you may want to do that using powershell as you normally would if you were running the program using the command line yourself. Once run, you may need to obtain a result from this command. I recently had to do this myself when working with the Google Translate API using VBA. This is easy to do in VBA. Checkout the below example, using a PowerShell command from VBA to get the user’s free disk space.
Continue reading “How to Use VBA To Run a Powershell Command and Get Return Value”