title: VBA code help opening file with differnt name
body: <p>I have a Macro i made and can't seem to get it to work correctly. 
  If i run the macro and pick a file in a folder with multiple files of the same type. 
  it only opens the first file in the folder. know matter what file i try to open, it will re-open the same file. for example. if i have 3 files with the names
  cycle0001 , cycle0002, cycle0003 when ever i try to open file 003 it opens file 001 always. the code works great except i can't open the file i would like. 
  only the file with the lowest number in the name. </p>
  
  <p>Here is my code. </p>
  
  <pre><code>Sub jsonDataExtractor()
  '
  ' jsonDataExtractor Macro
  ' Json Data Extractor
  '
  ' Keyboard Shortcut: Ctrl+t
  '
  
  File = Application.GetOpenFilename( _
  FileFilter:=" (*.json), *.json", _
  Title:="Select a file or files", _
  MultiSelect:=True)
  
  Application.ScreenUpdating = False
  
  
  Workbooks.OpenText filename:= _
  "cycle*.json", StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
  ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=True, Comma:=True, _
  Space:=False, Other:=True, OtherChar:=":", FieldInfo:=Array(Array(1, 9), _
  Array(2, 1), Array(3, 1)), TrailingMinusNumbers:=True
  </code></pre>