Making filepath variable

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:

Please Login or Register  to view this content.

which at one instance would give lets say

Please Login or Register  to view this content.

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

Hi xlbiznes,

yeah as i said i might be wrong about what it can represent I wasnt sure if numeric or alphanumeric but the point is it is single one.

anyways issue still remains, how to make it work....any suggestions?

Soul

Hi,

i see i swap those two it should be first xy for days (looping through 0 to 3 and 0 to 9) and then the marks, but it doesnt matter atm....;-)....issue is the same

output is that it doesnt refer to ? as a symbol that can represent anything but as a solid mark (so when it loops results is like ??_25_??)

EDIT1: and if i put those marks out of the quotes it doesnt work at all some vba error stops it from working not even runtime

ok, thx, I´ll try tomorrow morning when i get back to my PC at work...thx mate

Hi again,

so I´ve tried (using * instead of the question marks to get more gerenal result) and it works on my workstation aswell, so it seems that the problem is not the code but the hardware of my colleague...:-/....i was wondering what´s wrong with the code when it was running for quite long without issues and so it proved that nothing is wrong with it....anyways thx for your insights and help

Best regards

Soul