how to call a file same extension but different name.

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?

The following code will loop through all of the CSV files in a specified directory - I don't know if that helps you:

Please Login or Register  to view this content.

thanks for your reply ... but i couldn`t make it work