title: Excel VB Filepath Concatenation not Working
body: <p>I have a macro in an Excel xlsm file designed to open and close a number of csv files within a certain folder while extracting information from them. The following is representative of the code:</p>
  
  <pre><code>Dim wbPath As String
  Dim PathTextPart2 As String
  Dim FName As String
  
  PathTextPart2 = 123456
  wbPath = ThisWorkbook.Path  '="H:\Folder"
  FName = Dir(wbPath &amp; "\" &amp; PathTextPart2 &amp; "PathTextPart3*.csv")
  Workbooks.Open (FName)
  </code></pre>
  
  <p>The macro fails because FName returns "123456PathTextPart3789.csv", somehow leaving off "H:\Folder\" at the beginning of the string.  I have searched for solutions to my problem, but did not find any.  Can anyone spot what the problem is?</p>