XLRunCode>XLBookHandle,VBACode
Not supported in Macro Scheduler Lite.
This function requires Microsoft Excel to be installed.
Runs the specified valid VBA Code.
Important
For XLRunCode to work 'Trust Access to the VBA project object model' must be enabled in Excel:
In Excel go to File/Options -> Trust Center -> Trust Center Settings -> Macro Settings.
Under 'Developer Macro Settings' enable 'Trust Access to the VBA project object model'
Abbreviation: XRC
See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetCell, XLGetSheetDims, XLGetSelectedCell, XLGetSheetNames, XLOpen, XLQuit, XLRun, XLSave, XLSelectRange, XLSetCell, XLSetCellColor, XLSetRangeFormat, XLSheetToArray
Example
XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlH
//run pure VBA code to set the color
XLRunCode>xlH,ActiveSheet.Range("B12").Interior.Color = vbRed
//could be an entire block of code - let's create a bar chart
LabelToVar>vba_code,theCode
XLRunCode>xlH,theCode
/*
vba_code:
Range("A1:B11").Select
ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select
ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$B$11")
ActiveSheet.Shapes("Chart 1").IncrementLeft +50
ActiveSheet.Shapes("Chart 1").IncrementTop -30
*/