Getting Info into the browser

[A_Pitts]

One of the most important parts of the quoting process is calculating the freight cost. I have a hyperlink to the page and manually enter the Zip code and weight information, but, of course, I want to automate this process.I have a URL for the page that I need. I know I can use Concatenate to bring the new Zip Code into the URL, but I'm not able to paste this into the browser with a macro. The macro stops as soon as I leave Excel. Any ideas?

 

[Jim North]

If you change it to a hyperlink you can call the browser directly from Excel. Check out hyperlink in the help text.

 

[A_Pitts]

I know how to create a hyperlink, but I want to pull a zip code from a separate cell, add it a previous copy of the URL, and then have the browser open at the page that is indicated by the zip code. I can do it manually, but I would like to have a macro that would run from a button.
Thanks for the response.

 

[Juan Pablo González]

You can still do that with the HYPERLINK formula, and concatenating the URL and the ZIP address.

 

[A_Pitts]

That works. Thanks.