C
Chris L
I've been using Excel to create PDF invoices for my small home business (with
the official MS Export to PDF add-on), and include suitable payment links to
allow clients to quickly and conveniently settle their invoices. However,
I've noticed that dynamic URLs (i.e. those which make use of cell values with
the =HYPERLINK function) are not retained on PDF export. In the resulting
PDF, they're formatted as though a link (underlined, different colour etc.),
but they do nothing.
In the mean time I use static hyperlinks to take the client to a payment
gateway, where he/she will have to manually enter the invoice total. I'd
really love it if I could use dynamic hyperlinks to automatically use the
invoice total value in a direct payment URL to PayPal, for instance.
Please, if anyone can help with this bug, I'd hugely appreciated it.
Thanks,
Chris
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...bcfbc84&dg=microsoft.public.excel.crashesgpfs
the official MS Export to PDF add-on), and include suitable payment links to
allow clients to quickly and conveniently settle their invoices. However,
I've noticed that dynamic URLs (i.e. those which make use of cell values with
the =HYPERLINK function) are not retained on PDF export. In the resulting
PDF, they're formatted as though a link (underlined, different colour etc.),
but they do nothing.
In the mean time I use static hyperlinks to take the client to a payment
gateway, where he/she will have to manually enter the invoice total. I'd
really love it if I could use dynamic hyperlinks to automatically use the
invoice total value in a direct payment URL to PayPal, for instance.
Please, if anyone can help with this bug, I'd hugely appreciated it.
Thanks,
Chris
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...bcfbc84&dg=microsoft.public.excel.crashesgpfs