Opening excel spreadsheets via excel.application object w/o prompts

[Andy S.]

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/d...tml/wrgrfexcelapplicationobjectproperties.asp


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

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

 

[Andy S.]

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/micr...ct+update+links&rnum=1&hl=en#36b2ed9cfcbed5bb

 

[Guest]

Without any code posted I can't comment specifically but there is an argument
of the open method which specifies what you want to do with the links. Off
the top of my head I believe it is UpdateLinks:= True (or false).