Office VBA Macros You Can Use Today phần 4

Một khi bạn click OK trong hộp thoại Customize, ghi vĩ mô bắt đầu. Tới Format | Bullets and Numbering và làm theo các bước cần thiết để tạo ra các định dạng số ưa thích. 6. Khi bạn đã hoàn tất các thiết lập và bác bỏ Bullets and Numbering hộp thoại, | Word Procedures Figure 45 - Naming and Storing a Macro in Word Wrd 5. Once you click OK in the Customize dialog box the macro recording begins. Go to Format Bullets and Numbering and follow the steps required to create the preferred numbering format. 6. When you have finished making the settings and dismissed the Bullets and Numbering dialog box stop the macro recorder by clicking the Stop button on the Stop recording toolbar by double-clicking the REC button on the status bar or by using the Tools Macro Stop Recording command. 7. Test the macro by selecting some paragraphs then clicking on the new button. Tip If you make a mistake simply start over. The macro recorder will overwrite the first macro if you give it the same name. In order to view the macro open the New Macros module in the project where the macro was created. View the Appendix to learn how to open the VBE and locate the NewMacros module. The macro recorder generates code for formatting all nine outline numbering levels even if changes are only made to the settings for a few of the top levels. Office VBA Macros You Can Use Today page 121 Word Procedures Finding and Replacing in Multiple Documents This procedure demonstrates how to use common Office dialogs and how to loop Find through all parts of a document. Wrd Scenario The macro recorder is useful but when the result is played back the behavior does not always correspond to what happens in the user interface. One excellent example of this is recording Edit Find or Edit Replace. In the user interface Find and Replace processes the entire document including headers footers footnotes and drawing objects. It is rather a nasty surprise to find out that the recorded macro only works in the current document story that is the main body OR the header OR the footer OR the drawing objects. The macro recorder also cannot record looping through and processing all the files in a selected folder. Example file and This macro combines these .

Không thể tạo bản xem trước, hãy bấm tải xuống
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.