title: import to excel a text file using cell value
body: <p>I have some .txt output files that I would like to import in excel.</p>
  
  <p>Ideally I want to use Sheet1 as an index; where I will write a title, the name of the sheet and the path and name for the .txt file. The Macro should create a newSheet named as the cell and in that sheet import the corresponding .txt file.</p>
  
  <p>I been trying to record a macros and to changing the VBA code, but so far just failures.</p>
  
  <pre><code>With ActiveSheet.QueryTables.Add(Connection:= _
  "TEXT;C:\Documents and Settings\UserXP\My Documents\My Dropbox\CIPPEC\1-MIRA\Procesamiento base\OEDE\Tablas\trim\q_employ_pcia_23.txt" _
  , Destination:=Range("$A$1")).Name = "q_employ_pcia_23"
  </code></pre>
  
  <p>Any idea?</p>
  
  <p>Thanks</p>