Edit An HTML Hyperlink Address To Current File Name

Have an HTML hyperlink in the body of an excel email. Mr. Leith Ross was kind enough to assist me with the code.

The hyperlink works great, it directs to the folder in which the file exists.

If I want the hyperlink to open the file directly, how can I change the URL to get it do to that. The trick is that the filename changes based off a cell value in the worksheet.


Here's the URL:

URL = """file:///" & "S:\PROJECTS\Bakery Maint\Jason\CAR's Currently Routing"""

Here's the file name:

ext = "S:\PROJECTS\Bakery Maint\Jason\CAR's Currently Routing\"
wbName = Sheets("Approvals").Range("A5").Value
ActiveWorkbook.SaveAs Filename:=ext & wbName



Thanks for any help anyone can provide..

Hello WJO,

You can do it this way. Note the Chr(34) is the ANSI code for a double quote.

Please Login or Register  to view this content.