Problem Solved!
Contrary to my previous statement, the path and filename are needed.
To ensure the file is recognized as a csv, it is best to use the .open method as follows:
workbook.open Filname:= mypath & myfile, Format:=2

Thanks
Olivier