Click to See Complete Forum and Search --> : Excel Workbook


bv1to1
July 18th, 2001, 12:12 AM
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")