SQL Connection
Hi All,
I want to have the code for .Connection = ???? to represent ActiveWorkbook sheets("Temp 1")in the following part; With Sheets("TempData").Range("a1").QueryTable .Connection = ???? .CommandText = myCmd .Refresh BackgroundQuery:=False End With Thanks, Adul |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com