Variables in command lines

[Russell]

Why doesn't this work?
Is there a better way to import a .csv file into excel 2000?

Public Sub Get_CSV()
Set CSV_Connection = Worksheets(1).Cells(8, 65)
Set CSV_Name = Worksheets(1).Cells(7, 65)
With
ActiveSheet.QueryTables.Add(Connection:=CSV_Connection,
Destination:=Range("A1"))