Printable View
Hi all,
I programmatically open up an Excel File and do some stuff with it. This is all good.
However it has links in it, so I get that annoying message asking me whether I want to update them when I open the workbook. Is there anyway to stop this message or automatically tell it 'no'?
Thanks
J.
Hi,
You'll want to be looking at the Excel.Application.Displayalerts call to sort this one! ;)
Thanks for replying Alex.
But I actually use the displayalerts all the time, but it does not seem to get rid of this message. Every other one yes, but this one no :(
ahh weird, have you tried calling this one beforehand:
Application.Workbooks(1).UpdateLinks xlUpdateLinksNever
Hmmm....
I get a compile error on that one - doesn't recognise 'xlUpdateLinksNever'
Actually I dont even have 'updatelinks', just the singular 'updatelink' which wants a link name parameter etc.
I am using Access 97 here, referencing the Excel 8.0 library. Will that make the difference?
Ahhhh...checking on MSDN I am guessing this is an Office XP thing.
Bugger.
Drat, yeah just checked that out myself - it looks to be XP only - back to the drawing board! :p :rolleyes:
OK, we have Application.AsktoUpdateLinks = False....
But....
This then counts as pressing 'Yes' so does the whole updating thing :(
Close but no cigar
Heh I'm at home now using Excel 2000 & have the 97 help files with me now rather than XP - I just found the same one you did: Excel.Application.AskToUpdateLinks = False, but then spotted this explanation from MSDN:
You're right this one is no good whatsoever, but.... I did find that there is a parameter you can set on the workbook open method:Quote:
"True if Microsoft Excel asks the user to update links when opening files with links. False if links are automatically updated with no dialog box. Read/write Boolean."
Excel.Application.workbooks.Open _
Filename:="C:\Path\file.xls", Updatelinks:=false
Since you're opening the file through code, you should be able to set this parameter & solve youur problem...Quote:
I programmatically open up an Excel File and do some stuff with it. This is all good.
Superstar! :)
Thanks for all your help mate.