View Full Version : Update Question
anthony20069
01-07-2009, 04:15 AM
Hi guys,
When you link a worksheet with another - is there a way to auto update it without having that popup window open everytime you open the workbook that is linked to another one?
Cheers
Anthony
bdayboy
01-07-2009, 04:33 AM
This isn't helpful, but maybe you could try using commas in your sentences :P
Have you tried cellotape?:banghead::banghead:
anthony20069
01-07-2009, 04:35 AM
If you have nothing usfull to say, please be quite.......RICHARD!!!
bdayboy
01-07-2009, 04:40 AM
If you have nothing usfull to say, please be quite.......RICHARD!!!
:devil2: SORRY!
georgiboy
01-07-2009, 04:44 AM
I run Excel 2007 so it is slightly different, maybe you could use something like this.
Application.DisplayAlerts = False
'workbook to update from
ActiveWorkbook.UpdateLink Name:="C:\Example\Example.xls", Type:=xlExcelLinks
Application.DisplayAlerts = True
Hope this helps
Bob Phillips
01-07-2009, 05:10 AM
If you have nothing usfull to say, please be quite.......RICHARD!!!
Whilst you may not have appreciated that point, it was a valid comment that your question was hard to read, and your response is not very good etiquette for someone seeking help.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.