I'm trying to programatically open and read worksheets in a spreadsheet.
The problem is I get an interactive prompt that says "The workbook you
opened contains automatic links to information in another workbook. Do you
want to update this workbook with changes made to the other workbooks? To
update all linked information, click Yes. To keep the existing information,
click No.". This prevents my ActiveX script from finishing because it
requires interactive feedback from the user. Is there anyway to just make
excel go with the defaults?

I've been experimenting with the interactive and display alerts properties
shown in the link below to no avail. Any ideas?

http://msdn.microsoft.com/library/de...properties.asp


--

*************************************************
Andy S.


Please remove "noreply" before replying.

*************************************************