Hi
try
myFilename = MGR_SHORT_NAME & Sheets("Inputs").Range("E11").Value &
"SUMPRF"
& ".L00"

Also check the content of the variable 'MGR_SHORT_NAME'
you may include the line
msgbox myFilename
and check the concatenation



--
Regards
Frank Kabel
Frankfurt, Germany


Grace wrote:
Is there something wrong with the following code?

myFilename = MGR_SHORT_NAME + Sheets("Inputs").Range("E11").Value +
"SUMPRF" + ".L00"

It keeps bombing out when it goes to find this file, because the
actual file, of course, was named so that it has the MGR_short_name
in the front part of its name, but the macro doesn't seem to
recognize it, i.e., when it responds that it cannot find the file,
the name it says it is looking for, does not have this first part.

Thanks,
Grace