How to insert web source into Excel?

Question

Referring to following link, I have tried to insert following link into Excel without luck, and would like to know on any other approach to do that.

Does anyone have any suggestions?

Thanks in advance for any suggestions

http://www.weather.gov.hk/cis/dailyElement\_e.htm?ele=MSLP&y=1935

Answer 1

My suggestion in that case is to search the internet using the following search string

"excel vba import content from web site"

OR in Excel. . . .Data>From Web

Gord

Answer 2

Sorry for the brief description, I need to reword my statement, I would like to use macro to load URL and insert content of web page into Excel, not clicking on link.

Do you have any suggestions?

Thank you very much for any suggestions (^v^)

Answer 3

Do not alter the macro

Copy the url just as you show in your first post.

Paste into B2. . . .select B2. . . . .run the macro then click on the newly created hyperlink and see Hong Kong 1935 weather stats

Gord

Answer 4

If I place URL in Cell B2, could you please describe more on where to place URL within your coding?

Do you have any suggestions?

Thank you very much for any suggestions (^v^)

Answer 5

Copy the string you show then paste into a cell in Excel.

Select that cell then run this macro.

Sub MakeHyperlinks()

'David McRitchie

Dim Cell As Range

On Error GoTo endit

    For Each Cell In Intersect(Selection, _

            Selection.SpecialCells(xlConstants, xlTextValues))

        With Worksheets(1)

            .Hyperlinks.Add Anchor:=Cell, _

                    Address:=Cell.Value, _

                    ScreenTip:=Cell.Value, _

                    TextToDisplay:=Cell.Value

        End With

    Next Cell

    Exit Sub

endit:

    MsgBox "not text"

End Sub

Gord