I am getting the
Run Time Error 5: Invalid Procedure Call or Argument
on this line:
With ActiveSheet.QueryTables.Add(Connection:=User_File_Path, Destination:=Range("$A$1"))
I have a message box right before that line that tells me the User_File_Path, which is populating, and when I hover over the Connection:=User_File_Path it does display the file path as well... not sure how to fix this. Any help is appreciated!!