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

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.

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

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.

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

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).
--
HTH...

Jim Thomlinson


"Andy S." wrote:

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.

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