خرید بک لینک

I want to create a web query with that will add info like (Account used, useame (emails), password)

I created a web query already. Please find below the code.

My problem is the fact that I have 5 accounts and I want to be able to logout and to login and I don't know how can I do this.

The code is ruing smoothly, but this is just because I used, when I created the macro with the recorder, my login details for one account.

I would like to know how can I change the code so I can login or logout.

With ActiveSheet.QueryTables.Add(Coection:= _
    "URL;https://xx/transummary", Destination:=Range("$A$1"))
    .CommandType = 0
    .Name = "transummary"
    .FieldNames = True
    .RowNumbers = False
    .FillAdjacentFormulas = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = False
    .BackgroundQuery = True
    .RefreshStyle = xlInsertDeleteCells
    .SavePassword = False
    .SaveData = True
    .AdjustColumnWidth = True
    .RefreshPeriod = 0
    .WebSelectionType = xlSpecifiedTables
    .WebFormatting = xlWebFormattingNone
    .WebTables = "3"
    .WebPreFormattedTextToColumns = True
    .WebConsecutiveDelimitersAsOne = True
    .WebSingleBlockTextImport = False
    .WebDisableDateRecognition = False
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With
End Sub

برچسب: نویسنده: استخدام کار تاريخ: جمعه 20 فروردين 1395 ساعت: 20:11

صفحه بندی