TAILIEUCHUNG - Excel 2007 VBA Programming for Dummies P2

What Is VBA? VBA advantages You can automate almost anything you do in Excel. To do so, you write instructions that Excel carries out. Automating a task by using VBA offers several advantages: Excel always executes the task in exactly the same way. (In most cases, consistency is a good thing.) Excel performs the task much faster than you can do it manually (unless, of course, you’re Clark Kent). If you’re a good macro programmer, Excel always performs the task without errors (which probably can’t be said about you or me). If you set things up properly, someone who doesn’t know. | __Chapter 1 What Is VBA 15 VBA advantages You can automate almost anything you do in Excel. To do so you write instructions that Excel carries out. Automating a task by using VBA offers several advantages Excel always executes the task in exactly the same way. In most cases consistency is a good thing. Excel performs the task much faster than you can do it manually unless of course you re Clark Kent . If you re a good macro programmer Excel always performs the task without errors which probably can t be said about you or me . If you set things up properly someone who doesn t know anything about Excel can perform the task. You can do things in Excel that are otherwise impossible which can make you a very popular person around the office. For long time-consuming tasks you don t have to sit in front of your computer and get bored. Excel does the work while you hang out at the water cooler. VBA disadvantages It s only fair that I give equal time to listing the disadvantages or potential disadvantages of VBA You have to find out how to write programs in VBA but that s why you bought this book right . Fortunately it s not as difficult as you might expect. Other people who need to use your VBA programs must have their own copies of Excel. It would be nice if you could press a button that transforms your Excel VBA application into a stand-alone program but that isn t possible and probably never will be . Sometimes things go wrong. In other words you can t blindly assume that your VBA program will always work correctly under all circumstances. Welcome to the world of debugging and if others are using your macros technical support. VBA is a moving target. As you know Microsoft is continually upgrading Excel. Even though Microsoft puts great effort into compatibility between versions you may discover that VBA code you ve written for Excel 2007 doesn t work properly with older versions or with a future version of Excel. 16 Part I

• Tin học văn phòng
• Tin học văn phòng
• Quản trị mạng
• Cơ sở dữ liệu
• Công nghệ thông tin
• Tin học
• Đề thi Tin học văn phòng
• Câu hỏi thi Tin học văn phòng
• Bài thi Tin học văn phòng
• Ôn thi Tin học văn phòng
• Luyện thi Tin học văn phòng
• Tài liệu Tin học văn phòng
• Ôn tin văn phòng cán bộ công chức
• Ôn thi tin văn phòng
• Đề thi tin văn phòng
• Bài tập về tin học văn phòng
• Hướng dẫn ôn Tin học văn phòng
• Trắc nghiệm tin văn phòng tuyển công chức
• Ôn tin trắc nghiệm Tin văn phòng
• giáo trình tin học văn phòng
• bài giảng tin học văn phòng
• sử dụng tin học văn phòng công nghệ thông tin
• sử dụng tin học văn phòng
• kinh nghiệm sử dụng
• sử dụng máy tính
• tin học văn phòng chuyên nghiệp
• tài liệuGiáo trình tin học văn phòng
• thủ thuật văn phòng
• Tin B văn phòng
• Lý thuyết Tin B văn phòng
• Tin văn phòng
• Lý thuyết Tin B
• Tin học văn phòng Word
• Tin học văn phòng Excel
• Tin học văn phòng Powerpoint
• Chứng chỉ tin học văn phòng
• Đề thi chứng chỉ tin học văn phòng
• Ôn thi chứng chỉ tin học văn phòng
• Chứng chỉ B tin học văn phòng
• Đề thi chứng chỉ B tin học
• Ôn thi chứng chỉ B tin học