Share via

Hyperlink.CreateNewDocument Method

  • Article
Excel Developer Reference

Creates a new document linked to the specified hyperlink.

Syntax

expression.CreateNewDocument(Filename, EditNow, Overwrite)

expression   A variable that represents a Hyperlink object.

Parameters

Name Required/Optional Data Type Description
Filename Required String The file name of the specified document.
EditNow Required Boolean True to have the specified document open immediately in its associated editing environment.. The default value is True.
Overwrite Required 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.

Example

This example creates a new document based on the new hyperlink in the first worksheet and then loads the document into Microsoft Excel for editing. The document is called “Report.xls,” and it overwrites any file of the same name in the \\Server1\Annual folder.

Visual Basic for Applications 
  With Worksheets(1)
    Set objHyper = _
        .Hyperlinks.Add(Anchor:=.Range("A10"), _
            Address:="\\Server1\Annual\Report.xls")
    objHyper.CreateNewDocument _
        FileName:="\\Server1\Annual\Report.xls", _
        EditNow:=True, Overwrite:=True
End With

See Also