From a destination workbook, you can easily open the source workbook of an external reference.For example, you might want to verify that it is the workbook that you want the external reference to point to, or make changes to the source workbook. I hope this question is not too confusing and I appreciate your help! Second, what do I need to replace in the sub (it looks like provider, data source, initial catalog, etc) and where do I find the info to replace them with?
s Conn String = "Provider=SQLOLEDB; Data Source=INSTANCE\SQLEXPRESS;" & _ "Initial Catalog=My Database Name;" & _ "Integrated Security=SSPI;" ' Create the Connection and Recordset objects. Any Excel workbook you’ve linked to will have that workbook’s filename in the link with its .xl* file extension (like .xls, .xlsx, .xlsm), so a recommended method is to look for all references to the partial file extension.If you’re linking to another source, you’ll need to determine the best search term to use. Close Else Msg Box "Error: No records returned.", vb Critical End If ' Clean up If CBool(conn. Close Set conn = Nothing Set rs = Nothing End Sub First of all, would this work?Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.