XLRun does not do anything

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
terencepjf
Newbie
Posts: 15
Joined: Wed Dec 19, 2007 9:16 pm

XLRun does not do anything

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
Newbie
Posts: 15
Joined: Wed Dec 19, 2007 9:16 pm

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

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

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts