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.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.342706 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO