• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Load sheet with changing name

Dear all,

I have a .csv in a folder: P:\Projects\PROJECTEN (cl] Continue\Continue\Finance\Verwerken\ that is called: 2023-07-19-08-40-50-bunq-transactieoverzicht.csv

Loading the folder like this works:

Code:
Set Wb1 = Workbooks.Open("P:\Projects\PROJECTEN (cl] Continue\Continue\Finance\Verwerken\2023-07-19-08-40-50-bunq-transactieoverzicht.csv")

However, when I try to open it like this it does not work. It gives the following error:

"Sorry, we couldnt find...."

Code:
Dim LastLink As String
LastLink = Dir("P:\Projects\PROJECTEN (cl] Continue\Continue\Finance\Verwerken\*.csv")
MsgBox LastLink

Any thoughts on what I am doing wrong here?
 
I have no more idea than to use VBA Dir function I already gave you on another forum …​
Why this wild cross posting rather than continue on your original thread ?‼​
 
Back
Top