Good morning folkls.
I'm a bit in a jam.
I'm trying to make multiple query based on two column.
Here what I have for now:
I'm trying firstly to change the adress in the code "https://Webpage.com" and to use "Webquery" adress that is in a cell.
Please Login or Register to view this content.
Also to change the name "Test" with "Queryname" name that is also in cell.
Anyone can help me with that?
That would be greatly appreciated.
Like this...
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
WOW!!! Quick reply.
But just replacing ""https://Webpage.com"" with " & WebQuery & " doesn't work... it gives me a error at .Refresh BackgroundQuery:=False.
Also I tryed just to replace Location=Test with Location=" & QueryName & " and it give me a error at the same place.
And what about the other places with TEST
I cannot test it but give this a try...
Since WebQuery and QueryName depends upon the ActiveCell, make sure the correct cell is active. Or better first debug the code by pressing F8 key and check the values of WebQuery and QueryName variables.Please Login or Register to view this content.
Duplicate post.
Ok... For the Query naming... it works.
As for the " & WebQuery & ", it work with """ & WebQuery & """.
Thx for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks