Runtime 1004 after prompting for filename but not when filename hard coded.

FileName is given an array of values by Application.GetOpenFileName
FileName(1) would refer to the first value in there

If more than one file is selected, you can refer to them with FileName(2), FileName(3), etc.