You omitted a period between ActiveWorkbook and Name. This is the correct code:

macroString = "'" & activeWorkbook.Name & "'!MakeFinalVendors'"