LoadFromFile Method

Microsoft Office Object Model

LoadFromFile Method

       

Updates the text in the Microsoft Script Editor with text from the specified file (on disk).

expression.LoadFromFile(Filename)

expression   An HTMLProjectItem object.

Filename   Required String. The fully qualified path of the text file that contains the text to be loaded.

Example

This example determines whether the specified HTML project item is open; if the item is open, the example then loads script from the specified file.

If ActiveWorkbook.HTMLProject.HTMLProjectItems _
    .Item(1).IsOpen Then
    ActiveWorkbook.HTMLProject.HTMLProjectItems _
        .Item(1).LoadFromFile ("C:\MyScript.txt")
Else
    MsgBox "The HTMLProjectItem is not open."
End If