Home Run Time Error 5: Invalid Procedure Call or Argument
Reply: 0

# Run Time Error 5: Invalid Procedure Call or Argument

user515
1#
user515 Published in June 21, 2018, 6:30 am
 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!!
 You need to login account before you can post.
Processed in 0.342706 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO