Hi, how to open excel workboook (the excel file resides in a web server eg http://portal/excel/ttt.xls) without alerting the challenge response?
I want to bypass the challenge response, how to do that?
eg
Set xlApp = CreateObject("Excel.Application")
Dim strDocPath As String
strDocPath = FilePath
strDocPath = strDocPath & "Templates/"
Set xlBook = xlApp.Workbooks.Open(strDocPath & "ttt.xls")
