EXCEL OPEN: Difference between revisions
From Macros Wiki
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Command|syntax=EXCEL_OPEN <filename>, [<vis>] | {{Command|syntax=EXCEL_OPEN <filename>, [<vis>] | ||
|description= | |description=:Opens an existing excel document for use in the macro. | ||
|param1=<filename>|param1_desc={{filename}} | |param1=<filename>|param1_desc={{filename}} | ||
| Line 7: | Line 7: | ||
===Example=== | ===Example=== | ||
: | :EXCEL_OPEN "macro.xlsx", 1 | ||
[[Category:Excel]] | [[Category:Excel]] | ||
Revision as of 20:54, 22 July 2010
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
