Transfer Spreadsheet - call macro first

Experts, I want to call an excel macro before transferring the spreadsheet.  How could I do this?

name of macro:  "Transpose"

Private Sub cmdImport_Click()

         Dim strName As String

            CurrentDb.Execute "delete * from [Import_FC]"
            strName = "Forecast"

   DoCmd.TransferSpreadsheet acImport, , "Import_FC", "C:\Users\johnsoat\Desktop\Import_FC.xlsm", True, strName & "!"

Select allOpen in new window

End Sub