Excel VBA Variable in URL

Question

I would like to include a variable in a Google search URL. The URL, at present is:

IE.Navigate "https://www.google.com/search?q=DNR-12-1G+$+Price"

How would I replace the emboldened URL text with a defined string variable such as "pn"? Thanks

PS - I would also like to know how to replace the above with the contents of a cell. — Bob
– Bob, Commented Aug 13, 2016 at 12:32

Dave · Accepted Answer · 2016-08-13 14:47:24Z

1

To use a variable all you need is to substitute the text with it

IE.Navigate "https://www.google.com/search?q=" & pn & "+$+Price"

That would do the job. If you wanted to use the content of a cell, either set pn to the cell value like this:

pn = ThisWorkbook.Worksheets(1).Range("A1").Value

Adjust as necessary for your worksheet and cell address... or refer to it directly in the Navigate step:

IE.Navigate "https://www.google.com/search?q=" & ThisWorkbook.Worksheets(1).Range("A1").Value & "+$+Price"

answered Aug 13, 2016 at 14:47

Dave

4,3562 gold badges26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1