Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reconnecting a Link
I receive an Excel generated dialog in the following circumstance:
- 2 workbooks, sourcewb and destinationwb - destinationwb has links from named ranges on multiple sheets in sourcewb - the names of the sourcewb ranges are identical local names on different sheets Now: - with destinationwb closed, on of the sourcewb sheets is deleted and sourcewb is saved. - when destinationwb is opened, and links are re-established, Excel generated a dialogue asking the user to specify the sheet that the broken link refers to. Selecting cancel causes an error on the link. All this is fine, except I wish to prevent the Excel dialog from being displayed to the user since this process is under VBA control. Any thoughts would be welcome. Alex J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reconnecting a workbook connection from Access-Excel | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
How to aviod reset of Pivot filters when reconnecting to database? | Excel Discussion (Misc queries) |