OpenInWorksheet

The OpenInWorksheet method opens an existing document in the worksheet. Returns a Document object.

Syntax

object.OpenInWorksheet( filename, options)

 

Parameter	Type	Description
filename	String	required, file's full path and file name including extension
options	Variant	optional, default = "" specifies the automation import options for the selected file type

 

Example 1

This example demonstrates how to open an excel worksheet

Set MultiSheetxlsx_Sheet1_doc = Grapher.Documents.OpenInWorksheet("D:\Temp\MultiSheet.xlsx","Sheet=Sheet1")

 

Used by: Documents collection