If I use the following code, with a path in Cell A1, it works. However, if the path has a space in it, then it will not work. This is for Excel 2003. I suspect there must be a way to allow it to have a path with spaces in it (i.e. "Program Files").
Open Cells(1, 1) & "\file.txt" For Output As #FileNo