I have a query with web address like this, http://www.xxxxxxxx.com/Example/cgihistory.cgi?id=1111&begin=2001&end=2008
Is there a way when I input a 4 digit no. (eg. 2222) in cell A1, the value in theweb query address (1111) is changed to (2222),
http://www.xxxxxxxx.com/Example/cgihistory.cgi?id=2222&begin=2001&end=2008
Is there a way when I input a 4 digit no. (eg. 2222) in cell A1, the value in theweb query address (1111) is changed to (2222),
http://www.xxxxxxxx.com/Example/cgihistory.cgi?id=2222&begin=2001&end=2008