Guo Shanhui: Use Excel forms to organize useful web site data

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Recently, the company's website is doing external links, so collected some friendship link platform, personal independent blog and other data, data is made of Excel form, because these data in Excel form to make it will be more intuitive and convenient.

Every day I open a friendship link platform or personal Independent blog Excel datasheet, and then a location open the link in the datasheet, in one by one to refresh, comment operation. About the statistics, in the Excel table to open 100 URL links about 20-30 minutes, of course, my Computer configuration and speed are relatively good.

This afternoon to do the promotion of the company Friendship Link Platform Refresh, feel like such a site to open the link is really too tired, and the following may also collect more other platform data, so I was wondering if there is any way you can click to open an Excel form all the links. After a while on the internet search for a while, really let me find a way, this method is to use Excel "macros" to achieve, the online tutorial written a little fuzzy. In order to help more friends save time, feature an article detailing how to open hundreds of links in the Excel table.

First, we open any one containing multiple URL links to Excel data table, and then press ALT+F11 into the Code editing page, the following figure:

Attention to see, the figure of "Sheet1 (Twitter)" Table name is what we want to operate, double-click Sheet1 (Twitter) This table will pop-up code input window, the following figure:

We then enter the following code in this Code box:

Sub opens multiple links at the same time ()

Dim i As Integer, n as Integer

n = 100 ' number of links opened at a time, self-change

For i = 0 to n–1

ActiveCell.Offset (i, 0). Hyperlinks (1). Follow

Next

ActiveCell.Offset (n, 0). Activate

End Sub

After losing the above code, the system will automatically save the code entered, directly close the Code window.

The second step is to set up Excel macros, go to the Excel data table just now, and then in the menu – Tools – Macros – Macros – select "Open all links in Excel form Guo Shanhui", as shown below:

Click on the bottom right corner of the window "Options", then pop-up shortcut key settings, shortcut keys we can set to CTRL + any key, of course, as far as possible, do not have conflict with other shortcut keys, such as I was set to Ctrl key, the following figure:

Then we'll make sure that all the settings are complete.

Three, now we start the actual operation, first use the keyboard to select a list of links to the top of the link cell (do not use the mouse to choose, because the mouse will choose to open the link directly, the keyboard selection will not open the link), and then press the key we set just CTRL shortcut keys, The program will automatically open the following 100 links by just the number of code settings (n = 100 ' number of links opened at once).

Note: This is a simple code, can only handle the URL in the same column table link, run to no linked cell, the program will automatically stop error.

This article from Guo Shanhui Blog, the original link http://www.guoshanhui.com/154.html, by Guo Shanhui original writing, welcome reprint, Reprint please indicate the source URL, thank you.