marcvanderpeet12
Member
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:
However, when I try to open it like this it does not work. It gives the following error:
"Sorry, we couldnt find...."
Any thoughts on what I am doing wrong here?
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?