Please can someone let me know if the following is possible and if so how.
I'm trying to create a dynamic URL that passes name and value pairs to a website from an excel sheet.
Basically calculations are carried out within Excel and various results are obtained. These results then need to be checked in a web based database.
I can bypass the normal input page for a website by appending name and value pairs as follows where a request is made for a specific car.
madeupdomainofmysite.com/carview.php?Car=2
When clicking upon the link the page extracts the name and value pair and asks the database for car number 2.
This is OK if I wanted to create lots of links (one for each car) but I need to pass multiple name and value pairs and would like to create a single URL that can be built up from various elements within a sheet.
Whilst I'm OK with combining multiple dynamic references within Excel to select a specific cell within Excel I am coming unstuck in dynamically creating this kind of URL as I only seem to be able to edit the URL manually by right clicking.
Any thoughts on how to create dynamic web based PHP URL's?
Cheers
Bookmarks