I have an image in my excel workbook that functions as a dynamic hyperlink, ie it references two cells to get data to send to the browser. This is a PAYNOW link for my merchant payment gateway. What I want to know is how to add this link to an image in my page?
Here is the link that works when I use =HYPERLINK
=HYPERLINK("https://payjunction.com/live/shop/snap_check_out?store=***********&description=Invoice:"&N3&"&price="&N57&",&need_to_tax=no&need_to_ship=no")
When I add an image to the page, ie a PAY NOW" Button and try to add a hyperlink to it I use the above code and it is screwing with the cell references, when I click the link I get this:
file://localhost/=HYPERLINK(%22https/:😛ayjunction.com:live:shop:snap_check_out%3Fstore=kru*****&description=Invoice/%22&N3&%22&price=%22&N57&%22,&need_to_tax=no&need_to_ship=no%22)
You can see that its messing up on the quotes, I have tried removing the =HYPERLINK function but that doesnt work I get this:
https://payjunction.com/live/shop/s...price="&N57&",&need_to_tax=no&need_to_ship=no
The problem appears to be in how excel or html handles the " but I dont know how to fix it.
Any help would be great.
Here is the link that works when I use =HYPERLINK
=HYPERLINK("https://payjunction.com/live/shop/snap_check_out?store=***********&description=Invoice:"&N3&"&price="&N57&",&need_to_tax=no&need_to_ship=no")
When I add an image to the page, ie a PAY NOW" Button and try to add a hyperlink to it I use the above code and it is screwing with the cell references, when I click the link I get this:
file://localhost/=HYPERLINK(%22https/:😛ayjunction.com:live:shop:snap_check_out%3Fstore=kru*****&description=Invoice/%22&N3&%22&price=%22&N57&%22,&need_to_tax=no&need_to_ship=no%22)
You can see that its messing up on the quotes, I have tried removing the =HYPERLINK function but that doesnt work I get this:
https://payjunction.com/live/shop/s...price="&N57&",&need_to_tax=no&need_to_ship=no
The problem appears to be in how excel or html handles the " but I dont know how to fix it.
Any help would be great.