Hi,
I have the following problem. I hope someone is able to offer me help.
When I want to import an existing file from a excel file stored in my computer, i use the following lines of codes:
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;Z:\Kim\Sept 2003\2003\home\ftp\pub\account\lmp\20030930.csv" _
, Destination:=Range("A1"))
The problem is, I have to import many files for each day, namely, 20030929
,20030928 ... How can I add a parameter variable into codes like this?
So, I want something like this (but obviously this doesnt work)
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;Z:\Kim\Sept 2003\2003\home\ftp\pub\account\lmp\2003[date].csv" _
, Destination:=Range("A1"))
So, I just need to input "date" (0929, 0927...etc)
Thanks,
Kim