HOW DOES EXCEL AUTOMATICALLY GET THE DATA IN THE DIALOG BOX?

1. Ctrl+R, enter cmd, press enter.

Enter echo %path% to see all the environment variables.

2.Enter echo %classpath% to view the configuration of classpath.

3.Enter set test=d: test to create a new environment variable. The variable name is: test. The variable value is: d: test

4.Enter echo %test% to see the configuration of the test variable.

This can be written ** to read and put into excel!

<> if the data of ** is updated every day, you can right-click the mouse in the queried ** to refresh the data, so that Excel can query and update it in the background.

If you extract the complete **, you can also use VBA, and you can use Excel's built-in web query function.

Step 1: Excel2003: Open Excel, locate the cell location (such as A1) where you want to get data, and then click "Data" - "Import External Data" - "New Web Query" 2007 and above: Click "Data" - "Self".

3. After clicking, it becomes a check mark (indicating that the ** is selected), and then click "Import".

4. The dialog box pops up, click "OK".

5. If the data in the network is updated, you can right-click in the data area cell and select "Refresh Data" to get the latest data.

If you only need part of the data, you can obtain the data into ** according to the above method and then use other functions to process it.

The text description involves a violation, please see the attached drawing.

1. First of all, we find a web page with ** to demonstrate, and then click copy**.

2. Then, we open Excel, click on the menu bar "Data" tab, and click on the ribbon "Self".

5. At this time, we found that the data in ** was imported to Excel.

If you want to obtain structured data, and continue to obtain new data, you have to use tools to assist, at present, the Bowei software robot can easily collect all kinds of visible data on the web page or software vendors, and the output after collection is also structured. The table structure can be set one by one according to your corresponding excel**, after setting it once, you can realize long-term one-click data collection, and the output after each collection is the excel after the data update.

Excel-Data-Import External Data-Create Web Query-Enter ** in the dialog box-Enter-Select content-Click Import in the lower right corner-You can set it in the "Data Area Properties".

Although I haven't tried to get web page data in excel**, but if you haven't found a good way, I think the software robot tool should also be able to help you, the software robot is to collect the data of the web page, save it to excel**, if there is an update, it will be updated after collection.

Excel can't get data from web pages at all, and I'm the only one who can do that.

Here's how:

1. First of all, open the media tool "Notepad", copy and paste the data in the word file to be imported into Notepad, and then save it as a txt file.

2. Open Excel**, click the "Data" tab, and find "Self Text" in "Get External Data".

3. Click "From Text", the next window will pop up, select the txt file named 1 you just saved, and click "Import". Since there are only three file types by default: TXT, CSV, and PRN, you need to convert Word to TXT in advance.

4. The text import dialog box pops up, select the default fixed width, which means that the data corresponds to the cells one by one. If you select the separator, all the data imported will be in one cell, then click Next.

5. Set the branch line, in fact, it is the control of the number of imported data columns, click the mouse, you can add the branch line at any location. Double-click on any branch line to delete it. When you're done, click Next.

6. Set the format of the output data, generally do not need to make any settings, select the general, click "Finish".

7. The import is complete.

Insert an excel sheet in Word like this:

Click on the Insert toolbar in Word.

Click the Object button.

In the Object dialog box that opens, click the "Create by File" tab, where you can click the "Browse" button and find the table you want to insert.

The table inserted in this way can be modified in Word, and it is carried out according to the function of Excel.

Have you found a way to do it?

If you've been able to create a summary query in Access, you're ...... to create a summary table

Now, all you need to do is link these Excel sheets with fixed locations and names to the Access database, and you can use the data in the same way as an Access data table......

For the table you want to use, if the table name or the number of tables are different every month, it is more troublesome, you need to use VBA to do it, if you are not very familiar with **, it is not recommended to do this......

Suggestion: First, fix the table name and the number of tables (you can preset the empty table without data) and then link it to access, and then when the excel data is updated, paste the table with the same name directly into this directory .........

In this way, you can basically do ...... with a regular query

After taking a look at the ** you uploaded, it seems that this** does not quite match your actual use! You know, you have to give examples that are close to reality, otherwise the answers that will be given to you will not help you much! Your current data structure can only be the operation of summing the data in access, and there is no other choice!

That is, the data information is too single......It's no easier to get access than it is to do it in excel ......Therefore, please also carefully drop the structure of the ** for your specific practical use!

Can you provide test data and more detailed descriptions of the features?

Close the pop-up window.

do until findwindow(vbnullstring, "microsoft internet explorer") >0 doevents loop winhwnd = findwindow(vbnullstring, "microsoft internet explorer") 'Get the message window handle if winhwnd <>0 then'Close the Microsoft Internet Explorer message window btnhwnd = findwindowex(winhwnd, 0,"button", "OK") 'Get the OK button handle sendmessage btnhwnd, wm lbuttondown, 0, byval 0'Click the "OK" button (press the left button) sendmessage btnhwnd, wm lbuttonup, 0, byval 0'Click the "OK" button (release the left button) end if end with end sub to report. Beg.

Use sql, select manuscript name, author address, zip code from access table name, but determine the access location in advance.

What can be achieved is just to write some macros ** to do it.

Connect to Access and execute SQL statements to query, modify, and delete Access data!

Let's take Excel2003 as an example: assume that the A2:A100 region is the data input area.

Set the "Data Validity" before data entry:

Select the A2:A100 area wide pants field, click the menu "Data" -- select "Validity" to open the "Data Validity" dialog box, under the "Settings" tab, press the drop-down button on the right side of "Allow", and in the shortcut menu that pops up later, select the "Custom" option, and then enter the formula in the "Formula" box below:

countif($a$2:$a$100,a2)=1

Then click "Error Warning Label" -- select "Stop" in the "Style" box -- enter "Error" in the "Title" box -- enter "Record Duplicate" in the "Error Message" box -- click "OK".

When duplicate data is entered in the above cell area in the future, the system will pop up the prompt dialog box of "Record Duplicate" and refuse to accept the entered number.

2.It's okay to use the data filtering function, I haven't tried it.

The easiest way to do this is to see how someone else's table is set up in Excel (Data - Valid Data Source).

**How can you put more than one**Jane in it?,But you can put multi**button links.,A little button can pop up Cocoa Bi Ridge**,Equivalent to**Directory,If you want to do it, I can help you.。