EXCEL_FILE_NEW

EXCEL_FILE_NEW N

CREATES A NEW FILE (SHEET) AND ALLOCATES IT NUMBER N AS REFERENCE

  • Type: Command
  • Parameter: 1
  • Group: Excel

ACTION

The command EXCEL_FILE_NEW N creates a new file with the Microsoft Excel software, if it is running.

N is the number of EXCEL file on which the commands are targeted : it is the target file.

A file is a sheet in the vocabulary of Excel. It is possible to create several sheets simultaneously, they are identified by their number.

SYNTAX: EXCEL_FILE_NEW N

  • N = Excel file number (integer or real). Must be greater than 0 and less than or equal to the allowed maximum number of Excel files.

USE

  • The command is used to create a new sheet with Microsoft Excel.

ERROR

  • If Excel software is not running.
  • If number N is not a correct expression.
  • If number N exceeds the maximum of allowed file number.
  • If number N is not greater than 0.
  • If number N is in use.

EXAMPLE

rem launch Excel software

excel_start

rem wait for 5 secondes

wait 5000

rem create a new file

excel_file_new 1

SEE ALSO

EXCEL_START

EXCEL_STOP

EXCEL_FILE_CLOSE

EXCEL_FILE_OPEN

EXCEL_WRITE

EXCEL_READ$()