The following image shows you some of the data on worksheet "Data" Excel is not smart enough to know when you have added values to your data, the source cell reference won't adjust automatically.
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?
Data in an Excel workbook can come from two different locations.
If the external data source that you want to access is not on your local computer, you may need to contact the administrator of the database for a password, user permissions, or other connection information.
If the data source is a database, make sure that the database is not opened in exclusive mode.
I hope this question is not too confusing and I appreciate your help!