Commands & Syntax > Commands > Excel >

www.perfectkeyboard.com

 

Save - < excel_wb_save >() ... [Pro]

 

Excel: Save
<excel_wb_save>(Workbook identifier,"File path")
Available in: Professional edition

This command saves changes made to defined workbook.

 

#

Parameter name

Parameter description

1

Workbook identifier

A workbook identifier previously obtained by "open workbook" command.

2

File path

File to save the workbook to. If this field is empty then the workbook is saved to the file it was opened from.

 

Example (Macro Steps):

 

1

<#> <#>This macro shows how to save Excel workbook

2

Macro execution: ONLY COMMANDS

3

Excel: Open/Create workbook "" (Worksheet = "", Show = "Yes", Workbook identifier = "wbi")

4

Excel: Save Workbook identifier=%wbi%, File path=%_vFolder_Temp%\workbook

5

Excel: Close workbook "%wbi%" (SAVE = "No")

6

Message SHOW "Information" : "Workbook was saved to this file: %_vFolder_Temp%\workbook" (other parameters: x = -100, y = -100, Window title = Workbook Saved, Buttons = OK, Timeout (seconds) = 0, Always on top = No).

Example (Plain Text):

 

<#>This macro shows how to save Excel workbook

<cmds>

<excel_wb_open>("","",1,wbi)

<excel_wb_save>(%wbi%,"%_vFolder_Temp%\workbook")<excel_wb_close>(%wbi%,0)

<msg>(-100,-100,"Workbook was saved to this file:

 

%_vFolder_Temp%\workbook","Workbook Saved",1,0,0,0)