Invalid file name from valid source

[corquando]

Greetings:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Apologies if this is redundant. It’s half Excel & half Word, so perhaps I’m drifting out of phase a bit here.
<o></o>
Nonetheless, yesterday this bit of code worked fine:
<o></o>
DocName = CStr(Workbooks("Production Master").Sheets("OR").Range("A" + CStr(i))) 'define DocName for save
<o></o>
appWd.ActiveDocument.SaveAs Filename:="C:\Documents and Settings\nwa0tiu\Desktop\NAKA Attachments\" + DocName + ".doc"
<o></o>
Today, I get:
“Run-time Error 5152
“This is not a valid file name”
<o></o>
I’ve changed nothing. I set appWd as the object (Word.Application), opened the datasource, cleared the locked fields, set the first record . . .
<o></o>
Up to this point, it’s a standard mail merge macro. I’m simply retrieving the document name from a worksheet using relevant bits of data; the cell called in the DocName statement is a concatenation of these bits, in text format.
<o></o>
I copied the SaveAs path directly from the folder’s address box. When I hover the cursor over the variable DocName, I get the memo window displaying the correct name. Removing the ‘CStr’ solves nothing as well.
<o></o>
I am befuddled. Clues? I’m sure it’s something little and dumb.

 

[corquando]

Never Mind.

There's a "/" in the DocName concatenation. Like I said . . . "simple & dumb."

But thanks anyway. I'm sure it would have been found out sooner or later.

 

[jasonb75]

Wild guess, having not used macro's with word, try changing + to &
It looks like you should be concatenating not adding.

 

[corquando]

Howdy - looks like genius struck simultaneously. I discovered the problem at the same time your suggestion came in.

It was something little & dumb like that . . .

But this site is still the best by far for quick and substantial answers.

Thanks!