EXCEL OPEN: Difference between revisions

From Macros Wiki
Jump to navigationJump to search
ConnerO (talk | contribs)
No edit summary
ConnerO (talk | contribs)
No edit summary
Line 1: Line 1:
[[:Category:Excel|{{Up}}]]
{{Command|syntax=EXCEL_OPEN <filename>, [<vis>]
{{Command|syntax=EXCEL_OPEN <filename>, [<vis>]
|description=:Opens an existing excel document for use in the macro.
|description=:Opens an existing excel document for use in the macro.

Revision as of 14:30, 2 August 2010

Up

Command

EXCEL_OPEN <filename>, [<vis>]


Opens an existing excel document for use in the macro.

Parameters

<filename>
Filename as either text in double quotes, or a text variable.
If the filename does not contain full path information, then the file will be opened in the same folder as the macro.
[<vis>]
1 or 0 to determine whether the excel document window is visible or not.

Example

EXCEL_OPEN "macro.xlsx", 1