Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links in spreadsheet
Hello.
I need to open a series of spreadsheets in a directory, copy a worksheet from each and paste the worksheet into a new spreadsheet. All of this I can do, but the spreadsheets I have to open have links to other spreadsheets that cause the 'Update?' message box to appear. Is there a way to send a 'don't update' response click, or any other way to get around the message box? Thank you for your help. PeterW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links in spreadsheet
Hi Peter
See the tips on this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "PeterW" wrote in message ... Hello. I need to open a series of spreadsheets in a directory, copy a worksheet from each and paste the worksheet into a new spreadsheet. All of this I can do, but the spreadsheets I have to open have links to other spreadsheets that cause the 'Update?' message box to appear. Is there a way to send a 'don't update' response click, or any other way to get around the message box? Thank you for your help. PeterW |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links in spreadsheet
hi,
try this.... Application.DisplayAlerts = False 'your code here Application.DisplayAlerts = True regards FSt1 "PeterW" wrote: Hello. I need to open a series of spreadsheets in a directory, copy a worksheet from each and paste the worksheet into a new spreadsheet. All of this I can do, but the spreadsheets I have to open have links to other spreadsheets that cause the 'Update?' message box to appear. Is there a way to send a 'don't update' response click, or any other way to get around the message box? Thank you for your help. PeterW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet links | Links and Linking in Excel | |||
If I PDF a spreadsheet the Links don't work there - help | Links and Linking in Excel | |||
How do I get rid of old links in a spreadsheet? | Setting up and Configuration of Excel | |||
Spreadsheet links | Excel Discussion (Misc queries) | |||
Spreadsheet links | Excel Discussion (Misc queries) |