Multiple worksheets to find replacement tips

  
1. Find and replace with the workbook If these worksheets are in the same workbook document, then we can solve this problem by changing the option settings: press “Ctrl+H” key combination to open “ find and Replace the & rdquo; dialog box, click the "Options" button on the right, switch to the advanced operation mode, carefully check the "range" settings options, you can see the default range is "Worksheet", will It is modified to "workbook", so the scope of the search or replace is all the worksheets of the workbook, the effect is shown in Figure 1, the effect is obviously improved a lot. If you only need to find or replace some of the worksheets, you can hold down the Ctrl key to select and then open the “Find and Replace” dialog box. You don't need to change the scope to “workbook” directly Click the “All Replace & rdquo; or “ Find All & rdquo; button. 2. Finding and replacing different workbooks If you need to find and replace worksheets for different workbooks, consider grouping these worksheets into one workbook file, or by using third-party software or editing VBA code. Insert the VBA code as an example: Step 1: Prepare to create a workbook file named “ldld; compare table.xls”, set up as shown in Figure 2, and create a file named “Data Source”. Folder, put the workbook files that need to be replaced in batches in this folder, note that the above files must be placed in the same path. Step 2: Edit the VBA code Press “Alt+F11” to open the Microsoft Visual Basic for Application window, select “insert →module", insert a blank module in the right pane, manually enter or Paste the following code (code file download address: http://pan.baidu.com/s/1pJJKvSR) as shown in Figure 2, "MsgBox (" replacement is complete, please check check!")" The content in the ; can be set by yourself, if the path or name of the "data source" changes, please modify it according to the actual situation. After the code check is correct, select “file → close and return to Microsoft Word”, return to the Word interface, press “Alt+F8” key combination, click the "Run" button on the right, you can quickly Complete the replacement of multiple workbooks. After the replacement is completed, the dialog box shown in Figure 3 will pop up. In the future, if there is a similar demand, we only need to modify the contents of the “xtable” table.xls” "Microsoft Office 2015 Technology Preview Download" 
Copyright © Windows knowledge All Rights Reserved