July 1, 2002 at 3:46 am
Hi.
I have an excel workbook that I'd like to open it via a scheduler, however when it opens up it has an alert that says "The workbook contains automatic links to info in another workbook...Do you want to update this workbook..."
and then there is a YES/NO option. I'd like to switch this alert off as soon as it opens, How can I do this?
I've tried Excell.application.displayAlerts = false and didn't help.
July 7, 2002 at 2:14 am
dear Kuhdax,
try this:
Application.AskToUpdateLinks = False
regards
July 9, 2002 at 9:52 am
Well thnx man but this works the same as application.displayAlerts = false. They both do what I want them to do but, they still open the fileOpen dialog box, with its captio = "File not Found", and the File name text box = the xls file it is linking to.
Tnx for replying.
quote:
dear Kuhdax,try this:
Application.AskToUpdateLinks = False
regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply