Quote Originally Posted by Shazam
Ok my fault It was the file path I had to change. But it will only open the first workbook not the rest. It gives me this line error.

[vba]
FileName = Dir()
[/vba]

Run-time error '5':
Invalid Procedure call or argument
I figuered it out I had to changed it to:

[VBA]
FileName = r()
[/VBA]


Thank You so much vonpookie!