Hi Friends,

For below code, i need to create a macro which copy the URL from a cell and
pass on to the web query URL written in another macro:

ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.website.com", _
Destination:=Range("D20"))

Can you please advise how to pass on different parameters to above code?

Thanks in advance.

--
No one can steal your knowledge