how to pass on different parameters to VBA Code?
 

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

how to pass on different parameters to VBA Code?
 

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/

how to pass on different parameters to VBA Code?
 

Thanks Brown for your reply.

Let me rephrase my question:

Cell A1 contains URL. I want to pass on this URL to VBA code mentioned
below. The URL in cell A1 should be used in below VBA code:

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

Thanks in advance



--
No one can steal your knowledge


"Stan Brown" wrote:

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/