Adding variable to middle of string for querytables.add (to import daily files)

Good day all...

I'm trying to set up a little tool to help verify some data on a website against data in an internal corporate database. The website has a predictable URL we can use to obtain the data, where we have a date value in the middle of the string. I'm able to generate the entire string with no problem, but am not sure how to add that variable to the "querytables.add" command I got when recording the macro.

Here's what I have at the moment - "url" is the full string with the date variable. Any help is appreciated!

-- The objective here is simply to import the data from a CSV file saved online... if there's an easier/better way, I'm all ears!

Please Login or Register  to view this content.

Thank you for any help!

Delete the & " in this:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & url & ", Destination:=Range("A2")

to give:

Please Login or Register  to view this content.

Instead of a web query, have you tried File - Open - enter the URL as the file name?