how can i save a web page through vba

[anilg0001]

how can i save a web page through vba?

 

[anilg0001]

any one please
i need it urgently

 

[Jaafar Tribak]

Try this :

Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" _
(ByVal pCaller As Long, _
ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long


Private Sub DownloadFile(ByVal URL As String, ByVal Filename As String)

    Dim lRet As Long
    Call URLDownloadToFile(0, URL, Filename, 0, 0)
    
End Sub

Sub Test()
    DownloadFile "http://www.MrExcel.com", "C:\MrExcel.htm"
End Sub

 

[RoryA]

anilg0001,
Please read this. So far you have contravened only about half of the guidelines - please refrain from reposting basically the same question, labelling everything as urgent and bumping your posts repeatedly.

 

[anilg0001]

sorry mr. orya

Jaafar Tribak
i am trying to download and save the link

http://www.thirdage.com/d/dr/d-328496/birmingham/alabama/ali-kilic

but it not completely download

please review.