gpt4 book ai didi

Convert string variable to hyperlink (vba, excel)(将字符串变量转换为超链接(VBA,Excel))

转载 作者:bug小助手 更新时间:2023-10-24 17:55:12 31 4
gpt4 key购买 nike



I have declared variable

我已经声明了变量


Dim xFolder As String

After some steps this variable turns into string-link to the file (pdf) in the specified folder (on local drive):

执行某些步骤后,此变量将变为指向指定文件夹(本地驱动器上)中的文件(Pdf)的字符串链接:


xFolder = xFolder & "\" & "NFK_PKA _" & ActiveSheet.Cells(6, 3).Value & ".pdf"

After next few steps this variable is placed into body of an email:

在接下来的几个步骤之后,此变量被放入电子邮件正文中:


.HTMLBody = strbody1 & xFolder & Signature

But "pasted" link is a non-active text and I need that it will be changed to an active hyperlink to that file on our local drive

但“粘贴”的链接是一个非活动的文本,我需要它将被更改为活动的超链接到该文件在我们的本地驱动器上


Maybe any one can suggest some solutions where and how should I add converting of variable from text to a hyperlink?

也许任何人都可以建议一些解决方案,我应该在哪里以及如何添加从文本到超链接的变量转换?


更多回答

Is this what you need: stackoverflow.com/questions/52153992/…

这就是你需要的吗:Stackoverflow.com/Questions/52153992/…

I don't have Outlook to test it. As a html, you can try <a href="D:/temp/test.pdf">Click to View PDF</a>

我没有Outlook来测试它。作为html,您可以尝试单击以查看PDF

31 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com