Hi,
I have Excel 2003 with pivot tables connected to SQL Server 2000. I'm refreshing the Excel spreadsheet in a DTS package with ActiveX script. I also use the FileSystemObject to loop through the Excel files in the folder to refresh all the Excel files. When I call the Workbook.RefreshAll property, sometimes it seems to hang.

Is there some sort of timeout property in the Workbook or Application objects so that after some 15 minutes or so, it will quit and move to the next file?

Thanks in advance.