Runtime Error 13 .... Type Mismatch

You're missing some ampersands here:

Please Login or Register  to view this content.

Also, please use code tags:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

The Run Time error 13....Type Mismatch occurs in Step 6 and the SaveName2 string fails to evaluate. All of the other SaveName strings evaluate as intended. Is it possible that I have something incorrect in the Filename format?

Yes, as I've said you're missing an ampersand

I have altered Step 6 code as follows:
[code]ActiveWorkbook.SaveAs _
Filename:="\\NETWORK\shared\QUOTES\Bucket Elevator\" & SaveName1 \ "" & SaveName2 \ "" & SaveName3 & " " & SaveName4 & ".xls"[code]
All of the SaveName components evaluate properly, but I still get a Runtime Error 13 .... Type Mismatch at the end, seemingly associated with the .xls" portion. Any suggestions?

Yes, as I've said, you're still missing an ampersand:

Please Login or Register  to view this content.