Import dynamic filname

[Sevn]

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

[Alf]

Perhaps a construction along these lines if you a checking a number of files in a folder?

Please Login or Register  to view this content.

Alf

[Sevn]

not sure how to work that into my script, as I think I need the full filename to build my connection.

here's what I've got so far, and it works, but since the filenames will change each month, I need the strConnection variable to be dynamic.

again; any help will be greatly appreciated

Please Login or Register  to view this content.

[Sevn]

edit: double post

[Sevn]

ok, it's a little rough around the edges, but I got it figured out. Thanks for your help.

Please Login or Register  to view this content.

[Alf]

ok, it's a little rough around the edges, but I got it figured out.

Perhaps it is but it works and that is the main thing! Thanks for feedback and rep.

Alf

Ps As this seems to fix your problem don't forget to mark thread "Solved"

To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved