VBA - open a single .csv file in a folder

Question

I am trying to open a .csv using the following code, but it doesn't seem to work. My file is saved in a Downloads folder and there is only 1 file in that folder. Because the file name changes over, so I use the wildcard.

I am using the following code.

Workbooks.Open "C:\Users\" & Environ$("username") & "\Downloads\" & "*.csv"

The code looks completely alright . Wildcard will pick the first file on the directory. Have you checked whether the path exists ? Could you explain about the error a little bit ? — manoj0790
– manoj0790, Commented Dec 2, 2019 at 12:29
Hi manoj0709, it said "Sorry, we couldn't find...., is it possible it was moved,...". I tried with a file specific directory then it works, but the error comes up when I change the file name to a wildcard *.csv — Tony Nguyen
– Tony Nguyen, Commented Dec 2, 2019 at 12:35
You can use Environ$("userprofile") instead of "C:\Users\" & Environ$("username") — BigBen
– BigBen, Commented Dec 2, 2019 at 13:02

Andreas · Accepted Answer · 2019-12-02 12:38:01Z

2

Use dir() to find the filename, then open using workbook.open.

Fname = Dir("C:\Users\" & Environ$("username") & "\Downloads\" & "*.csv")
Workbooks.Open "C:\Users\" & Environ$("username") & "\Downloads\" & Fname

Or combine the two:

Workbooks.Open "C:\Users\" & Environ$("username") & "\Downloads\" & Dir("C:\Users\" & Environ$("username") & "\Downloads\" & "*.csv")

edited Dec 2, 2019 at 12:38

answered Dec 2, 2019 at 12:31

Andreas

24k7 gold badges34 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA - open a single .csv file in a folder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related