help compile script to exe

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
ibol123
Newbie
Posts: 1
Joined: Wed Jan 19, 2011 5:35 pm
Location: 111

help compile script to exe

Post by ibol123 » Wed Jan 19, 2011 5:44 pm

hi,
i created a simple script for a charity to automate their data entry into their accounting software using the evaluation copy of Macro scheduler.

it's a one off job and was wondering if anyone here can compile the script and turn it into an *.exe file for me. as it's a one off and a freebie job i can't justify buying Macro Scheduler just to compile this script so i thought i'd ask here.
if you can, i'd really appreciate it.

ian.

ibol123 AT gmail DOT com

the script is as follows:
-=============================
IfFileExists>C:\PAXDATA\DONATIONDATA.XLS,CHKWIN,NOFILE
Label>CHKWIN
IfWindowOpen>Donation Bookings,START,NOWINDOW
Label>START
//open excel file for entry

XLOpen>C:\PAXDATA\DONATIONDATA.XLS,0,xlBook
//retrieve heading information
XLGetCell>xlBook,DONORS,3,3,strRef1
XLGetCell>xlBook,DONORS,4,3,strRef2
XLGetCell>xlBook,DONORS,6,3,strComment
XLGetCell>xlBook,DONORS,3,6,strMoneyAc
XLGetCell>xlBook,DONORS,4,6,strDonationNom
XLGetCell>xlBook,DONORS,5,6,strGiftAidNom
XLGetCell>xlBook,DONORS,6,6,strFundCode
XLGetCell>xlBook,DONORS,9,3,strDate
//go to Paxton
SetFocus>Donation Bookings*
MoveWindow>Donation Bookings*,0,0
//change to paxton and enter heading information
wait>0.3
MouseMove>90,80
LClick
wait>0.2
Send Character/Text>strRef1
Press Tab
Send Character/Text>strRef2
Press Tab
Send Character/Text>strComment
Press Tab
Send Character/Text>strMoneyAc
Press Tab
Send Character/Text>strDonationNom
Press Tab
Send Character/Text>strGiftAidNom
Press Tab
Send Character/Text>strFundCode
Press Tab
Press Del * 10
Send Character/Text>strDate
wait>0.2
//get ready for donor input
Press>Tab *3
Let>rowPos=13
Let>colPos1=2
Let>colPos2=5
Let>strLen=0
label>getRow
XLGetCell>xlBook,DONORS,rowPos,colPos1,strDonorRef
XLGetCell>xlBook,DONORS,rowPos,colPos2,strDonationAmnt
Length>strDonorRef,strLen
//if cell is not blank do row entry
IF>strLen>0
//go to Paxton
SetFocus>Donation Bookings*
wait>0.2
Press>Right
//donor row entry
//enter Donor ref into paxton
Send Character/Text>strDonorRef
Wait>0.1
//move to the amount column
Press Right * 3
//enter Amount into Paxton
Send Character/Text>strDonationAmnt
Wait>0.1
//move to the next row
Press Down
wait> 0.1
Let rowPos=rowPos+1
goto>getRow
ENDIF
MessageModal>Finished data entry. Click OK to continue.
XLQuit>xlBook
CloseWindow>Excel*
goto>END
Label>NOWINDOW
MessageModal>Donation Bookings window not open. Ensure you are in the Donation Bookings window of Paxton.
goto>END
Label>NOFILE
MessageModal>No file exist for data entry. Ensure you have C:\PAXDATA\DONATIONDATA.XLS.
Label>END


the script

idiot
Macro Veteran
Posts: 152
Joined: Thu Mar 01, 2007 9:21 am

Post by idiot » Mon Jan 24, 2011 9:06 pm

well they do have a download that will let you try out the script compiler for a limited time or you could just do the same thing in C programming and compile it there using the free student version but making programs with this compiler is much easier and effecient and take alot less knowledge of coding
if idiots rule the world then im the king!!!!
i want a free t-shirt give me all of your rep!!!
please give me pro version of macro scheduler and appnavigator!!!

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