Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Are Form 944 Pr Fractions

Instructions and Help about Are Form 944 Pr Fractions

Hi, my name is Stephanie Krieger and I'm a Microsoft Office MVP. In this video, I'm going to be demonstrating a few tasks from the article titled "Using VBA to Format Long Documents in the 2007 Office System in a Fraction of the Time." You can find that article on the MSDN Office Developer Center. Well, most of what I'm going to show you can apply to your work with VBA in many office programs. But since this demo is about formatting long documents, let's go ahead and jump over to Word. If you record macros, you know that those macros can save you a lot of time on repetitive tasks, like formatting the sixty-eight tables that I copied from Excel into the sample report. For example, but you also know that recorded macros have limits. So, in this example, I would need to run the macro separately for each table, right? I'd need a different macro for each type of table that requires unique formatting. And I'd probably still have to take some actions manually for things that I can't record. Alright, well in this demo, we're going to look at a couple of different types of VBA constructs that you can use to save a lot more time than that. First, we're going to look at a loop, which is a type of statement that enables you to loop through multiple instances of an object, such as to apply your formatting to all tables in the document at once. And next, we're going to look at conditional statements, and that lets you see how you can execute different actions in the same macro based on conditions you specify, like when you need different formatting based on the type of table. Okay, so take a look at this document. I've got two different...