VBA: how to open the only .csv file existing in a directory

[Nelson78]

Hello everybody.

I've the following directory in my pc:

R:\Users\john.smith\Downloads

It contains two files, only one of them is a .csv. But, about it, I don't know the exact name.

How can I open it exploiting the only information I have? (it is a .csv file).

Thank's.

 

[Nelson78]

Hello everybody.

I've the following directory in my pc:

R:\Users\john.smith\Downloads

It contains two files, only one of them is a .csv. But, about it, I don't know the exact name.

How can I open it exploiting the only information I have? (it is a .csv file).

Thank's.

I've tried this way:

Workbooks.Open ("R:\Users\john.smith\Downloads\*.csv")

but it is opened without text to columns. On the contrary, if I open it manually the text is to columns like a normal .xls file...