L
latha
Hi
I am jsut using excel 2003 and sql server 2000 and dsn connection. I have an excel template and a command button. If I click on the button, it fills my excel sheet but everytime it fills my excel sheet, I am noticing extenal_data_1 , external_data_2..in the names list, it keeps increasing. I am pasting my code here. Please suggest me if anyone have any ideas to get rid of external_data_3.. or a better way of writing.
Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("A:C").ClearContents
sqlstring = "select * from test"
connstring = _
"ODBC;DSN=MagCardDev;Description=MagCardDev;APP=Microsoft® Query;DATABASE=MagCardDev;Trusted_Connection=Yes"
With ActiveSheet.QueryTables.Add(Connection:=connstring, _
Destination:=Range("dataarea"), Sql:=sqlstring)
.Refresh
End With
End Sub
Thanks
I am jsut using excel 2003 and sql server 2000 and dsn connection. I have an excel template and a command button. If I click on the button, it fills my excel sheet but everytime it fills my excel sheet, I am noticing extenal_data_1 , external_data_2..in the names list, it keeps increasing. I am pasting my code here. Please suggest me if anyone have any ideas to get rid of external_data_3.. or a better way of writing.
Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("A:C").ClearContents
sqlstring = "select * from test"
connstring = _
"ODBC;DSN=MagCardDev;Description=MagCardDev;APP=Microsoft® Query;DATABASE=MagCardDev;Trusted_Connection=Yes"
With ActiveSheet.QueryTables.Add(Connection:=connstring, _
Destination:=Range("dataarea"), Sql:=sqlstring)
.Refresh
End With
End Sub
Thanks