Excel VBA .csv upload with wildcards.

Hi all,
Iīve got a big problem which I canīt solve. So I have a folder with 3 .csv Files which change on a daily basis. I tried to automate a process in which
the 3 Files got imported under each other in Excel under one worksheet. I tried a workaround with DATE1=Date-3 or -1 but then Iīve got problems with the working days/weekends.
I tried to use * or ? as wildcards since the name of the file stays the same and only the date changes.
It would be wonderful if somebody could help me with this
Never the less I wish you all a wonderful weekend.
P.S.: Does anybody have an idea how I can connect the different rows when for example A ends and B starts? Since my solution for e.g.B with Destination:=Range("$A$30001"))
isnīt the most elegant.

Please Login or Register  to view this content.

It would help if you can upload sample csv file. That's representative of your actual csv, but desensitized.
Along with how imported data should look like in your workbook.

As per banner up at the top. You can desensitize the sensitive data (i.e. replace with generic string, like UserName1, UserName2 etc).

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Your first import is probably fine.

For the 2nd and 3rd import destinations, something like this maybe:

Please Login or Register  to view this content.