Sign in to follow this  
Followers 0
Walkabout

AutoIt3 made available to the masses

7 posts in this topic

#1 ·  Posted (edited)

Hi All,

I'm a long time lurker and big fan of AutoIt.

In the spirit of giving back to the community that has given me so much, here's my first contribution. It's not very well documented and is still really in Beta stage.

The idea is to enable people who cannot code to gain some of the benefits of AutoIt by creating simple scripts in a spreadsheet. The contents of send() commands or execute() commands can be put in a spreadsheet and this script will read those strings and either send or execute them in a specified window. I've also added an expandable help section (see screenshots) that will allow the user to copy some sample strings to the clipboard for repasting into the spreadsheet.

I've attached a sample spreadsheet as a CSV. It's pretty hard to come up with a more complex sample as everyone uses quite varied software.

ADEPT_1.5.6.au3

Regards

Walkabout

edit: uploaded new version 1.5.6 and re-named ADEPT (Auto Data Entry and Processing Tool).

Recycling.ico

Stop.ico

ADE_Sample_Sourcefile__Untitled___Notepad_.txt

ADEPT_Sample_file_CSV.txt

Edited by Walkabout

Share this post


Link to post
Share on other sites



@Walkabout:

Wow, that must be a record for longest script in first post.

Share this post


Link to post
Share on other sites

Hello,

I ran the script (copied from the code in your post). And it gave some errors.

C:\_\Apps\AutoIT3\test.au3(563,45) : ERROR: RefreshWindowList() previously called with 0 arg(s). Min = 1.

Func ReFreshWindowList(ByRef $OldWindowList)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^

Still in BETA or maybe some more documentation would be nice.

Share this post


Link to post
Share on other sites

Hello,

I ran the script (copied from the code in your post). And it gave some errors.

Still in BETA or maybe some more documentation would be nice.

Ptrex,

Thanks for your feedback. It ran fine on my PC at work, but I had the same problem as you when I ran it at home. Might be a Beta version thing. I've fiddled with it and it seems to be working OK on 3.1.87 now, though Au3Check does throw up an error about Execute(). Just ignore it.

I'm glad you looked in here as it was your little script using Execute that gave me the idea to do this B)

I've also uploaded a sample source file (Excel), and some screendumps of the GUI before running it. The second one shows the help expanded which allows the user to copy AutoIt3 commands to the clipboard for pasting into the source spreadsheet.

Regards

Walkabout

Share this post


Link to post
Share on other sites

@Walkabout

Thanks for the feedback.

Nice screenshots !!

I will update my Beta version today and try again.

your little script using Execute that gave me the idea

Glad you liked the Execute example B)

You can do a lot of cretive things with this, if you think about it.

Keep up the good work !!

Share this post


Link to post
Share on other sites

Updated script to deal with Excel "Cannot Empty Clipboard" error. For general reference, leave a short sleep (I've had success with 50ms) between a copy in an Excel Window and a Clipget(). Excel seems to do some post copy playing around with the clipboard which conflicts with the operation of Clipget().

Walkabout.

B)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0