Nope, no joy. Made it a Variant, still get the following:

Run-time error '-214767259 (80004005)';

This is not a valid filename.

HOWEVER, I just did what I probably should have done in the first place, and searched for that error number to discover the following, which looks promising. Will try it and post again here about the results after I've tried it. I'm optimistic, because when I checked the contents of my variable in the immediate window, it did indeed show the ".pdf" part on a second line....

Alright, I figured out the issue, mostly. I don't know why/where it is doing this, but it is adding a 'next-line' character (Chr(13)). So, right before telling it to save the file, I inserted the line:

pdfName = Replace(pdfName, Chr(13),"")
Now it is saving with no problem. My co-worker was helping me with this issue, and he found that if you took:

pdfNameLen = Len(pdfName)
it returns the length as 2 more than if you counted the visible characters (because of the 2 cell entries). He used:

Left(*cell text*, Len(*cell text*) - 2)
for where it collects both cell values, where the only difference is at the very end (-2 instead of -1, to get rid of the cell formatting and Char(13)). At the exact same time we said "got it!".