Excel macro to upload data to a website

[shaikhstonevilla]

Hi,

I have a ready csv file to be upload it to the website.

I want to upload this file to https://login.xero.com
i have the login id and password.

can anybody help me how can i do this ?


Kind regards,
Shaikhstonevilla

 

[footoo]

To open the website and login try :

Sub Login()
Dim IE As Object: Set IE = CreateObject("InternetExplorer.Application")
With IE
    .navigate "https://login.xero.com"
    Do While .Busy Or .readyState < 4: DoEvents: Loop
    .Visible = True
    .document.all.UserName.Value = "your loginID"
    .document.all.Password.Value = "your password"
    .document.all.submitButton.Click
End With
End Sub