Will the file path always be the same folder or do you mean that you have to
search for a particular file in an unknown folder on a drive?

If always in the same path then just record the macro to open the file. The
code should be something like this.

Workbooks.Open Filename:="K:\MyPath\My File To Open.xls"

--
Regards,

OssieMac


"dstiefe" wrote:

I want to open a file that is located on another harddrive and hence folder

how would I do that?