I'm trying to copy a table from the website to Excel,
The website require login with username and password.
How I embed that within the code?
Code
ActiveWorkbook.Queries.Add Name:="xxx", Formula:= _
"let" & Chr(13) & "" & Chr(10) & " Source = Web.Page(Web.Contents(""https://.......""))," & Chr(13) & "" & Chr(10) & " Data0 = Source{0}[Data]" & Chr(13) & "" & Chr(10) & "in" & Chr(13) & "" & Chr(10) & " Data0"
ActiveWorkbook.Worksheets.AddThank you