Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Range of variables with the 'floor' command included | Excel Worksheet Functions | |||
data table - lines variables for DB functions, charts.. etc.. | Excel Discussion (Misc queries) |