FYI: Google answered my question --

expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable,
Notify, Converter, AddToMRU

http://groups.google.com/group/micro...b2ed9cfcbed5bb

"Andy S." wrote in message
...
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.

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