i have a system which every week it generates afile Data_08-18-10_11-02-58.csv however the data will change according the day of compilation.

now i am writing a script to tailor this data inside .. however i am finding a problem to extrect the data from .csv to excel because of the specific name!

Sheets("Data").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Documents and Settings\ryan schembri\Desktop\ARsystem\Data_08-18-10_11-02-58.csv ", Destination:=Range("$A$1"))
etc.....................

(like this it will opens no problem but only for this day)

how can i write something generic such as *.csv (any name but ends with the extention .csv)

because when the file is updated and writes the new Date i cant open it as the code i wrote...

any help pls?