Variables in command lines
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_Connec tion, Destination:=Range("A1")) |
All times are GMT +1. The time now is 10:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com