Converting an IQY file to VBA formatting

Hey Folks. Hoping I can get some help here. I have an .iqy file (a web query that opens in Excel), that looks like this:

Please Login or Register  to view this content.

I'm trying to create a macro that generates this same connection, but I can't figure out how to pass along the variables.
It would look something like this:

Please Login or Register  to view this content.

But having the questionmark in the string to bridge the URL and the variables doesn't seem to do the trick.
Am I missing something here?

Thanks in advance!