I'm importing some CSVs that have names that change every month (oct13, nov13, dec13, etc.)

I would like to create a variable that contains a wildcard, but VBA doesn't seem to like what I've written.

If I write the whole file name in, it works correctly, but if I add in an *, it doesn't
  • This variable works --> strFileName = "Oct13_Future" & ".csv"
  • This is what I'm trying to accomplish --> strFileName = "*" & "_Future" & ".csv"

Any assistance would be greatly appreciated.

Thanks,
7