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
help compile script to exe
Moderators: JRL, Dorian (MJT support)
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!!!
i want a free t-shirt give me all of your rep!!!
please give me pro version of macro scheduler and appnavigator!!!