Hi folks,

so I´ve come across another issue today during my work. I needed to make a filepath variable due to the months and dates, but for some reason my previous piece logic is not working here and I wonder if I did it proper last time (cause it was done with trial&error method).

the thing is, the path is constant up till the end, so lets say its: "C:\users\name\desktop\folder\" and now I have quarter as folder and within i have file with dates (15_01_13 for example)

so the logic I used in the previous file for the loop and it worked was:

"C:\users\name\desktop\folder\" & i & "Q\??_" & x & y & "_??.xls"
which at one instance would give lets say

"C:\users\name\desktop\folder\1Q\11_02_13.xls"
but for some reason when i tried those question marks today again, they didnt work (old file is still working though). So I got two question - 1) Have I done something wrong....2) as far as I´m aware question marks should represent only numerical symbols (mby im wrong here too) but I need something that represent any symbol in any lenght (such as if you´re searching in totalcommander and you use * for undefined symbol or lenght) cant get that one working in vba code though

help is much appreciated

Best regards and thx for help guys

Soul