script updating data in excel with links stalling 1

[brepauls]

I am running various reports and saving as excel files with format. Those excel files are linked to a summary workbook which does further calcs, etc. I now need to copy the values from one of the workbook pages into other workbooks. Problem is when I open the workbook with links, I get a dialog box asking Y/N to update all linked information. How can I send a reply to that request from the script? Here is a snipet of the process where I'm using this:

Dim objExcel as Object
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = 1

objExcel.Application.Workbooks.Open "\\Dom1\Shared\Risk\Team Docs\Busn System Reports\Cargo Claims\Performance\Cargo Claims.xls"
objExcel.Application.DisplayAlerts = False
objExcel.Sheets("A##").Select

Workbook opens but waits for response of updating the links. Any and all help is greatly appreciated!!!!

 

[GJParker]

You coul dtry using the SendKeys statement

SendKeys "N"

HTH

Gary

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

If SendKeys hasn't solved the problem, have a look at
thread707-774802 for a similar issue solved with VB.


soi la, soi carré