Hi
what error do you get for this code?

--
Regards
Frank Kabel
Frankfurt, Germany

"StephanieH" schrieb im
Newsbeitrag ...
I'm trying to create a macro that will save my file in another
location each
month. On of the variables is a folder in the pathname. For some
reason, I
can't get it to accept my variable. Here's my example
MyValue = InputBox("Enter Month # ____ YYYY_MM", "Central Analytics")

Windows("MPA Internal.xls").Activate

ActiveWorkbook.SaveAs Filename:= _
"I:\EXLDATA\Loan Recovery MIS\" & MyValue &
"\Outstandings\MPA
Internal.xls",
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

I've tried \MyValue\ " & MyValue & " " MyValue " &MyValue&
nothings
working...
Help.