title: How to pass string to a function in VBA?
body: <p>I am trying to pass different table names as strings so they can be used in a function that will export the table I specify to an excel spreadsheet. I cannot get it to work because when I try to do the "DoCmd.TransferSpreadsheet" command, it says that it does not recognize "table_name". I thought that if I passed a string name with the name of the table that it would work, but apparently it doesn't. Am I passing the string wrong, or am I not allowed to do this? Also, what type of excel spreadsheet should I export it as? I didn't see the differences between the different types.</p>
  
  <pre><code>Public Function NAME_FILE(table_name As String)
  
  Dim strName As String
  Dim strLocation As String
  Dim strXLS As String
  Dim strFinalName As String
  
  strName = InputBox("What do you want to name the file?", "File Name")
  strLocation = "C:\folder1\"
  strXLS = ".xls"
  strFinalName = strLocation &amp; "" &amp; strName &amp; "" &amp; strXLS
  
  DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "table_name", strFinalName, True
  
  End Function
  
  Public Function EXPORT_PRODUCT_CODE()
  Dim T_PRODUCT_CODE As String
  
  NAME_FILE (T_PRODUCT_CODE)
  
  End Function
  
  Public Function EXPORT_CAMPAIGN_CODE()
  Dim T_CAMPAIGN_CODE As String
  
  NAME_FILE (T_CAMPAIGN_CODE)
  End Function 
  </code></pre>