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)