Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
With this code ....
When it reaches the line in red, Excel displays dialogue
"This workbook contains links to other data sources."
Question ... considering the code, would this be normal behaviour or is there an error with the code? Just wondering if I need to worry about it.
I've searched both documents for external links (Find links (external references) in a workbook - Excel) but nothing was found. I don't really know what links are being found to be updated.
If there is no need to be concerned, is there a way I can block this message from interfering with the flow of my application? Will displayalerts suspend this message?
Rich (BB code):
Dim wba_name As Workbook
Dim tCol As String
wba_name = "WS " & format(ws_vh.Range("B17"), "dd-mmm-yy") & ".xlsx"
If Dir(path_name & wba_name) <> "" Then '.tglb_wpl_crtt.BackColor = RGB(0,153,211)
Workbooks.Open (path_name & wb_name)
Set wb_name = Workbooks(wba_name)
...
When it reaches the line in red, Excel displays dialogue
"This workbook contains links to other data sources."
Question ... considering the code, would this be normal behaviour or is there an error with the code? Just wondering if I need to worry about it.
I've searched both documents for external links (Find links (external references) in a workbook - Excel) but nothing was found. I don't really know what links are being found to be updated.
If there is no need to be concerned, is there a way I can block this message from interfering with the flow of my application? Will displayalerts suspend this message?
Last edited: