While in debug mode enter this into the
Immediate pane (Ctrl+G if you can't see it):
Code:
?"C:\Documents and Settings\" & strUser & "\Desktop\Forecast\" & part1 & " " & part2 & " " & part3 & ".xlsx"
and press
Enter.
Examine the results and see if there's anything obvious:
Does the file already exisit?
Is the path and filename 100% correct?
Does the folder exist?
Are there any illegal characters in the name?
What is the error message?