XLRun does not do anything

terencepjf · Post by **terencepjf** » Mon Mar 28, 2011 2:33 pm

Hi; I was trying out the XLRun features and I can't get an Excel sub or function to execute..

[code]
//Open Excel File
XLOpen>%SCRIPT_DIR%\finance.xls,1,xlBook

//XLGetCell>xlBook,Sheet1,5,4,theValue

//MessageModal>Cell value: %thevalue%

Let>i=1
Label>Loop
Random>80,vNum
XLSetCell>xlBook,Sheet1,%i%,2,%vNum%,result
let>i=i+1
if>i5
XLRun>xlBook,ClearSheet
wait>5
xlSave>xlBook
XLQuit>xlBook
[/code]

ClearSheet is a simple test
Worksheets("Sheet1").Range("A1:A10").Clear

Thanks in advance

terencepjf · Post by **terencepjf** » Mon Mar 28, 2011 2:42 pm

Please cancel this post - I had the macro in the wrong file!!