Sat, 21 Apr 2007 08:38:00 -0700 from Ahmaq
:

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?

I think you mean you want to pass the URL in the currently selected
cell. If that's correct, see the Selection property in VBA help.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/