I am sorry to repost this but it looks like too much time is passed and the
solution never came. I have two statements that involve a string called
"strMGR_SHORT_NAME that are having problems. In the first case, the
statement is

fname = StrMGR_SHORT_NAME & Sheets("INPUTS").Range("B45").Value &
Sheets("INPUTS").Range("E11").Value & ".xls"

The compiler error message I am getting says "object variable or with block
variable not set." I am pretty sure this statement had been working but
somehow now is not. I have had it show me that variable, which is entered
thru an Input Box and it is what it's supposed to be. But the command is
not working. Does this error message tell anyone anything?

Then, this subroutine calls another subroutine where I use a similar
statement to try to open a file. In this case, the statement that is
crashing is:

myFilename = StrMGR_SHORT_NAME & Sheets("Inputs").Range("E11").Value &
"SUMPRF" & ".L00"

It was not an XLS file and that caused some confusion but it now seems
evident that the real problem is that this same strMGR_SHORT_NAME is now
blank and so is not automatically being "seen' by the called subroutine.
So, the solution for this seems to be merely to pass the result of the
INPUTBox along and so the question is, shouldn't a calling subroutine pass
its definitions along to a subroutine it calls? And, if not, how do I get
it to do so?

Thanks,
Grace