Run Time Error 1004 Can't read path

[EileenJohn]

Why it can't read my path code? I want it to copy all my workbooks in that folder.

Path1 = "C:\Users\user\Desktop\DailyRecord"
Filename = Dir(Path1 & "&.csv")
Do While Filename <> " "
Workbooks.Open Filename:=Path1 & Filename, ReadOnly:=True

 

[SQUIDD]

I Think you need another \ at the end?

Path1 = "C:\Users\user\Desktop\DailyRecord"

try that to start with

 

[SQUIDD]

Path1 = "C:\Users\user\Desktop\DailyRecord\"

 

[Tetra201]

Why it can't read my path code?

Because your Filename evaluates to "DailyRecord&.csv".
Then, you are trying to open "C:\Users\user\Desktop\DailyRecordDailyRecord&.csv".
How can this work?

 

[Norie]

Are you trying to get all the CSV files in the folder 'DailyRecord'?

If you are try this.

Path1 = "C:\Users\user\Desktop\DailyRecord\"
Filename = Dir(Path1 & "*.csv")
Do While Filename <> ""
    Workbooks.Open Filename:=Path1 & Filename, ReadOnly:=True