I want to open an excel file from https giving user and password, without popup asking for user and password, I am using this code (is working):

strFileName = "https://a.b.net/sites/xyz/File1.xls"
Set wbFile = Workbooks.Open(strFileName)

Thanks in advance