Also, the file will try to be opened inside the same directory that the script is running from. If this is not your intent you should specify a path along with the filename

Good advice specifying the full path, but Excel doesn't care about your current working directory or where the script is located.

Excel looks for the file in its "Default file location", usually My Documents. Check Tools->Options->General->"Default file location".