I'm trying to query a page in which I need to change parts of the url based on the information I want. Heres the url (with domain changed to protect info, rest is identical) I am trying to work with:

http://website.com/flb/recentactivit...=-1&tranType=4

I want to be able to change the parameters in bold. I have all of the parameters in a table, so if i could get the macro to reference the table thatd prob be easiest. In fact, the table is set up to combine parameters and automatically generate the URL I want. So I really just need the macro to reference one cell within the workbook to get the approriate URL I want query.

Whats the best way to do this? Hope my questioning isnt to confusing. Thanks!

Also posted this question on: http://www.mrexcel.com/forum/showthread.php?t=482261