Home > Forum Home > Automating Data Analysis Tasks > Download Historical NAV form web > Thanks for reply but i didnt get everyting Share

Thanks for reply but i didnt get everyting

Excel Help for Thanks For Reply But I Didnt Get Everyting in Automating Data Analysis Tasks


Forum TopicLogin

Thanks For Reply But I Didnt Get Everyting

Rate this:
(3/5 from 1 vote)
ConfusedHi

Thanks for reply, but i dont have proficiency in this language, Can you please assist further, as per my understanding i modify below mention code. How can i link sheet date with vba code, how to use loop statement.

Sub downloadnav()
Dim TxtDate As String
Const MyUrl As String = "URL;http://www.idbifortis.com/TrackNAV.aspx?lm1=1"
With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://www.idbifortis.com/TrackNAV.aspx?lm1=1", Destination:=Range("A1") _
        )
        .Name = "TrackNAV.aspx?lm1=1"
                .RefreshStyle = xlInsertDeleteCells
               .WebFormatting = xlWebFormattingNone
        .WebTables = """DGNav"""
               .Refresh BackgroundQuery:=False
    End With
End Sub

 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Thanks for reply but i didnt get everyting in the

© 2020 Business Spreadsheets   Legal   Follow us: