Having just purchased WinAutomation I am impressed by its power and I am looking forward to the numerous ways this software can increase my productivity. Presently I am working on a way to automate the putting up of bookmarks. My approach is as follows:

There are two Excel files: One which holds the data of Social Bookmark websites like URL, user name, and password. The other file consists of 30 rows each holding the data for the submission of one bookmark like target URL, title, and tags.

As I do not want to submit the same 30 URLs to every Social Bookmark websites I am looking for a way to randomize the number of submitted bookmarks as well as which URL to submit.

Therefore I would like to create a job where at the beginning I am asked for the number of URLs to be submitted. I assume that this can be down with a message box although I haven’t figured out a way how to do this.

After entering a number of bookmarks to be created the job should select the given number of URLs, in other words, rows, in the Excel spreadsheet. The rows should be selected randomly without choosing one row twice in one submission job.

Essentially it’s about establishing a kind of randomization mechanism which chooses rows in the spreadsheet but I wasn’t able to find a way how to achieve this with WinAutomation.

Creating the job which submits the data to the Social Bookmark websites is easy using the “Move Mouse to Image” and the “Tab” button. However, how to create a loop which restarts the submission process until there is no further URL to be submitted is presently also beyond my abilities.

To sum up:

1)    How do I create a message box which allows me to choose the number of bookmarks to be submitted?

2)    How do I create a mechanism which randomly selects a specified number of rows in an Excel spreadsheet?

3)    How do I create a loop which submits one bookmark after the other and stops after the last URL to be submitted?

I would be grateful if somebody could point me in the right direction. Many thanks!