Save As with Macro & Variable File Name

[stroobie]

I am trying to create the code to save a template down as a macro enabled workbook with a file name based on input from a userform. Here's what I have, and I keep getting an error message about the Workbook class. I've Googled a million times and some of what I have below is what I copied from recording a macro and still get an error - I am very stumped. Please help!

Please Login or Register  to view this content.

[gsnidow]

Are you sure 'jobno' has a value? What do you see if you put MsgBox(jobno) directly after the jobno= line?

[stroobie]

that was it... i was staring at the damn thing for so long i didn't realize i hadn't filled it out completely. thanks.