Excel update automatic links prompt

[coppertom]

I am using Excel automation to open an Excel file and extract data from a worksheet. However, if a file has a worsheet with linked cells, I get a message stating '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?' I have to click 'Yes' or 'No to continue running my application. Is there a property I can set so I am not prompted when I open a workbook with links? I can manually open Excel, go to the menu option Tools --> Options --> Edit and uncheck the box 'Ask to Update Automatic Links', but I would like to be able to turn it off in code and turn it back on when I'm done.

TIA,
Tom

 

[Mike Gagnon]

ox=CREATEOBJECT("Excel.application&quot
ox.Workbooks.Add
ox.DisplayAlerts
ox.DisplayAlerts=.f.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Gagnon]

sorry that should read:
ox=CREATEOBJECT("Excel.application&quot
ox.Workbooks.Add
ox.DisplayAlerts=.f.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[coppertom]

Is there anything I can do for an Excel workbook that has already been created by a user? I am just extracting data and not actually creating a worksheet in code.

 

[Mike Gagnon]

coppertom

Try this, set the DisplayAlerts at the application level.

ox=CREATEOBJECT("excel.application")
ox.DisplayAlerts=.t.
oWb=ox.Workbooks.Open("c:\book2.xls")

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[coppertom]

Mike

I tried that after your first post, but I couldn't get that to work. I then tried opening Excel, setting DisplayAlerts = .F., closing Excel, and opening Excel again but that didn't work either.

 

[Mike Gagnon]

coppertom

The DisplayAlerts is mostly for more regular things like "overwritng and existing file" or closing without saving. I don't think there is a solution for a link issue. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[coppertom]

I wasn't sure if there was either. Thanks for your help.

 

[kingdick]

Just in case others have this problem, in code before opening the file use Application.AskToUpdateLinks = False then load the file, then to resort the default use Application.AskToUpdateLinks = TRUE