Hyperlink.CreateNewDocument (Excel)

Creates a new document linked to the specified hyperlink.

CreateNewDocument (Filename, EditNow, Overwrite)


Dim strFilename As String: strFilename = 
ActiveCell.Hyperlinks(1).CreateNewDocument Filename:=strFilename, EditNow:=True, Overwrite:=True

Arguments

The following arguments are required:

Filename (String) - The file name of the specified document.

EditNow (Boolean) - True to have the specified document open immediately in its associated editing environment. The default value is True.

Overwrite (Boolean) - True to overwrite any existing file of the same name in the same folder. False if any existing file of the same name is preserved and the FileName argument specifies a new file name. The default value is False.