Hi

I am trying to create a web query through VBA, I have the code

Please Login or Register  to view this content.
But it tries to get a table from https://amazon.com/employee/ and ignores the employee ID. How do I get Excel to refer to the page https://amazon.com/employee/EE_Id? (EE_Id is a string variable, this is part of a loop where it adds a separate worksheet and query for around 300+ rows of a table).