Web Query - using a variable URL located in a cell

[Pippin66]

Hi, all. I'm having my first go at importing data using a Web Query using the following code:

Please Login or Register  to view this content.

The website URL I need to access is located in Range("A6"). How can I incorporate the URL in A6 into the Web Query?

Many thanks,

Darren

[Chippy]

Please Login or Register  to view this content.

[Pippin66]

Thanks, Chippy. I'm very new to VBA and even getting the syntax correct at this stage is a challenge! Your suggestion solved my problem, thank you.

Darren

[cdjindia]

I would suggest that you move destination of Web Query to A2. and move cell where you store URL to A1. Your code could read something like

Please Login or Register  to view this content.

Reason for this tip: When a web query refreshes, it often will clear out everything in its range (which is where your URL is)