HOW TO USE VB6 TO FILL IN THE CORRESPONDING DATA IN EXCEL TO THE NETWORK?

dim xlbook as

dim xlsheet as

set xlbook = & "091119") 'Open an existing excel workbook file.

false 'Sets the Excel object to be visible.

set xlsheet = "11") 'Set up an active worksheet.

with xlsheet

cells(1, 1).value

cells(1, 2).value

cells(1, 3).value

cells(1, 4).value

end with

end sub

The specific operation steps to fill in the data in Excel in batches into ** in Word are as follows:

1. First click to open the word application, click the "Insert" tab on the main page of this file, and then click "**" under the "Insert" tab.

2. Then click on the "Insert**" option in the pop-up option box.

3. Then click to go to the "excel" file you want to operate, select the data you need to operate with the mouse, and then click the "Ctrl+C" key on the keyboard.

4. Then open the word file, right-click in the first cell of ** that you just opened the settings, and then click in the pop-up option box to select "Paste".

5. Then you can see that the data selected in Excel has been successfully imported into Word.

1. After opening the text document, do it first, and then find the "Tools" button in the toolbar in the document.

2. After clicking, a command menu will pop up, in which you will find the "Mail Merge Toolbar", and after clicking the "Mail Merge Toolbar", a toolbar will appear in Figure 2 below.

3. Find the icon shown below in this toolbar and click to open the data source.

4. Then a selection box will appear, select the data source excel file that needs to be imported, and click OK.

5. Then click the mouse as shown below in the cell in the data file to be imported**, let the cursor always flash in this cell, and then click the icon "Insert Merge Field" on the second picture.

6. Then select the items you want to enter, click OK, and you can see that "Name" appears in the cell in the second picture, and the date of birth and gender can also be entered in the same way.

7. Then click "Merge to new document" as shown below, select the start line and end line of the data you want to import in the Merge to new document setting, and click OK.

8. Then you will find that all the data in excel are imported into the ** of the document.

Word's mail merge function is available.

Open the template with word, email - select recipients - use the existing list, find the excel file, open; Insert the field in the appropriate location to merge the operation.

This requirement is more convenient with Word's mail merge feature.

If there are more people, they have to switch to such a **.

Please use the mail merge and find out the specific method online

The following sentence is to open an excel document worksheet.

call "C: Testing. xls")

The following sentence is a text variable for reading out the contents of the excel document worksheet (1, 2) in cells (1, 2).

text = , 1, 2)

messagebox "The readout reads as:"&text Fill out the form after you've read it. If you fill out the form, you won't just look at the corresponding examples.

The following sentence is to close the excel document worksheet.

call

There is an option in the Find dialog with a range in the options and an annotation in the range.

Excel**, if you want to know how to find the remarks data, you must know how to create the remarks data, left-click the cursor to select the cell you want to fill in the remarks data--- right-click the cursor--- in the drop-down menu--- use the cursor to left-click to select (insert annotations) -- enter the desired after the Microsoft user: --- appears.

If you want to modify or delete a note--- left-click the cursor to select the cell with a triangle symbol--- right-click (Comment) to annotate the content, and if you select the lower (Delete Comment), you can delete the annotation content.

Right-click to display the annotation, if you want to search its contents, etc., it will not succeed.

The note is an annotation, right? You can work around by copying the content of the comment to a cell first, and then pressing the shortcut key Ctrl+F to find it, but you can't find it directly in the comment.

1. Open Excel and select all the items you want to arrange.

2. Then click Sort, ascending or descending order is also possible.

3. After clicking on ascending order, all the same names will be arranged together, and the other columns will also be arranged together.

4. Or select the name column and click Sort.

5. Check the Expand Selection area and click Sort.

6. The numbers are arranged together.

1. Open an excel first.

3. Select all of our data.

4. Come to the menu bar, we select "Data", and then select "Sort".

5. Select the main keywords that we sort.

6. Select "Gender" and click "OK".

With custom sorting, the first keyword is the name column, and the whole row changes with the name column, keeping the whole row unchanged for each row.

The sorting function and pivot tables can be realized, and it is relatively fast to sort by factor.

The column of the name is OK and then sorted by click, and the corresponding data also changes.

If you want to change the position of the name, the data will not change, and when you jump out of the box below, you should use the following option.

Just sort in the name column.

Select all your data regions (i.e., your name column and yellow data column), sort, if there is a header, select the header row, press the name column, ascending and descending, you can confirm.

There are 2 ways to open Excel in VB6, one is to use the DLL with Office to directly operate Excel according to Cell

This kind of comparison is not easy to go wrong, the other is to use ADO to connect to Excel, and use the Excel sheet as a table to operate, this kind of easy to go wrong, especially for hand-generated Excel

If the Excel is generated by a machine, it is recommended to use two connections to connect Excel and Access

Then read the recordset according to the standard method for data import and export.

If it is a manually generated Excel, it is recommended to use the Excel DLL with Office should be called Microsoft Excel Object Library, and then use the connection to connect to Access, by reading the Excel data, one by one to the recordset operation.

1. Open access, click on the external data in the toolbar, and click on excel.

2. Click Browse, select the excel** you want to import, click OK after selection, and click OK in Get External Data.

3. After clicking OK, the import data package wizard box will pop up, click Next, and then go to another step.

4. After clicking Next, click Next, then click Next, then enter the name of the data table you want to import in the box, and finally click Done.

What is the underlying data of sheet1 used for in this example?

Select the even-numbered column of sheet2, and enter the following formula, press Ctrl+Enter to finish.

if(a1="","","This year"&randbetween(5,8)&"years old")

Illustrate.

Step 2: Enter the formula =iferror(vlookup(e:e,a:b,2,0),""), and then copy and paste the formula to f3:f30

Then you must do a good job of this project in **.

Give you an automatic sub-department**, as long as you name the sheet name to each department, it will automatically take the personnel information of the main worksheet.

You can make a backup of an existing sheet and rename it to "Manufacture", and the data will be automatically generated (with enough formulas, of course).

This can be achieved well with VB**.