Hi,
if you are looping through the list of files using this filter :
"C:\users\name\desktop\folder\" & i & "Q\??_" & x & y & "_??.xls"
if we break this further & "Q\??_" & x & y & "_??.xls" -> the first two ?? stands for the day , what does x and y do ? and the last two ?? marks are for the year.
What is the output of this code ? do you see any spaces ?
Bookmarks