Power Spreadsheets

Excel provides you several options for formatting dates. In addition to the several built-in date formats that exist, you can create custom date formats. Even though the process of manually applying a date format isn't very complicated, there are some circumstances in which you may want to create macros that format dates. This may the case if, for example: You use a … [Read more...]

If you've worked with Excel before, you're probably quite familiar with 2 basic commands for saving workbooks: Save. Save As. It may not surprise you to know that, when working with VBA, you can carry out these same activities. In fact, knowing how to save Excel workbooks using VBA is essential. As you work with Visual Basic for Applications, you'll notice that saving … [Read more...]

One of the most basic and common operations in Excel is opening a workbook. Regardless of their level (beginner or advanced), virtually every single Excel user has to constantly open workbooks. In fact: You've probably opened a countless amount of Excel workbooks yourself. If you're working with VBA, it's only a matter of time before you need to start creating macros to open … [Read more...]