| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break a link to a data source
I have a template that imports external data (OBDC) and/refreshes upon
startup. Once opened, the user saves the file as a differnent name (.xlt to ..xls). When the user opens up the .xls, it automatically refreshes the data (problem if a new query was request from our MRP system). Is there a way with VBA to break the data link once the file is saved as an ..xls? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Need code here End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Link to other data source" - How can I find out what is linked? | Excel Discussion (Misc queries) | |||
| link source data | Excel Discussion (Misc queries) | |||
| Break a link/formula but keep the data? | Excel Worksheet Functions | |||
| How do I break a link to a source when opening Excel 2000? | Excel Worksheet Functions | |||
| Unable ot Break link for Macro with no source | Excel Discussion (Misc queries) | |||
Threaded Mode
