EXCEL OPEN: Difference between revisions
From Macros Wiki
Jump to navigationJump to search
New page: {{Command|syntax=EXCEL_OPEN <filename>, [<vis>] |description=*DESCRPTION* |param1=<filename>|param1_desc= |param2=[<vis>]|param2_desc= }} ===Example=== :- EXCEL_OPEN Category:Excel |
No edit summary |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{ | [[:Category:Excel|{{Up}}]] | ||
| | {{Command|syntax=EXCEL_OPEN <filename> | ||
| | |description=:Opens an existing excel document for use in the macro. | ||
|param1=<filename>|param1_desc={{filename}} | |||
}} | }} | ||
<br>Note: in GibbsCAM 2015 the drivers used to open excel documents were changed. | |||
<br> | |||
<br>You no longer need to have a copy of Excel on your system, but one effect of this is that the option to open an Excel file and to display it has been removed. | |||
<br>Microsoft no longer support the editing of an Excel file and reading the edited file from another application whilst it is remains open. | |||
<br>You need to open it (with Excel, or another application), make edits, save and close the file, only then you can open it to read it from a macro. | |||
<br>See the "ImportTools3.mac" in the "ImportTools example macro for one way of doing this. | |||
===Example=== | ===Example=== | ||
: | :EXCEL_OPEN "macro.xlsx" | ||
[[Category:Excel]] | [[Category:Excel]] | ||
Latest revision as of 18:08, 21 October 2015
Command
- EXCEL_OPEN <filename>
- 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.
Note: in GibbsCAM 2015 the drivers used to open excel documents were changed.
You no longer need to have a copy of Excel on your system, but one effect of this is that the option to open an Excel file and to display it has been removed.
Microsoft no longer support the editing of an Excel file and reading the edited file from another application whilst it is remains open.
You need to open it (with Excel, or another application), make edits, save and close the file, only then you can open it to read it from a macro.
See the "ImportTools3.mac" in the "ImportTools example macro for one way of doing this.
Example
- EXCEL_OPEN "macro.xlsx"
