I want to use Excel data to login to a list of FTP accounts and upload to all accounts specific files

Problem:

FTP Automation, I want to use excel data to login to a list of ftp accounts and upload to all accounts specific files

Solution:

The job displayed above describes how one can use the information retrieved from an Excel spreadsheet, to login and upload to each FTP account listed in the spreadsheet, specific folders found on our local machine.

Discussion:

We start by defining the folder that we want to upload the files of to each FTP account specified in our Excel file.

Having defined that, we launch our Excel file, and get the first free row and column.

Copy text and paste it after the formatting has been removed!

Wouldn’t it just be great if you could copy some text from a website or any other documents and not having to paste it in a notepad window and copy it again from there in order to achieve getting the text alone with no formatting and do all this with a single keyboard macro?

When using editors as Word or Excel or even Outlook and you copy paste a piece of text that contains any formatting what so ever, it pastes all it gets and it’s not really helpful having to re-customize what you just got!

Life is so eaaaasy with WinAutomation!…

How do I import the jobs that I created in WinAutomation v2?

WinAutomation v3 and its built-in macro recorder is fully backwards compatible: this means that all the jobs that you may have created in previous versions will be automatically detected and imported in v3. Moreover, besides the automatic job import during the installation process, you can also manually import in WinAutomation v3, jobs that have been created in previous versions.

In order to import jobs that are saved in an xml format, you will have to select the “File – Import Job” menu in WinAutomation’s console window. Then in the “Select Job to Import” dialog, you need to change the “Files of type” selection to “Xml Job Files”:

Then you can locate the job or jobs that you wish to import, select them and hit the “Open” button.…

Manage the delays between keystrokes

Either you are using the Macro Recorder to record your keystrokes, or you manually drag and drop the “Send Keys” action, sometimes you may need to change how fast the keystrokes are sent. WinAutomation provides you with 3 different tools to do that:

1) Set Playback Speed (“Tools – Set Playback Speed” in the Job Designer window): This option allows you to control the playback speed of your recorded macros. You can choose whether you want to execute the actions that you recorded without internal delays or exactly as you recorded them.

Notice that the “Set Playback Speed” option affects all recorded actions (including mouse movements and mouse clicks).…

Retrieve a specific cell’s value from a DataTable

If you use WinAutomation and Excel Macros to manipulate Excel files, you most likely came across the concept of Data Tables. Whenever you are reading a range of cells from an Excel file, the information that you acquire is stored in a variable that has a type of “Data Table”. Sometimes, you may want to retrieve a specific cell’s value. The easiest way to do that, is to use the “Read from Excel” action, and store a cell’s content into a variable. But what happens if you need to use the values of 50 different cells from the Excel file? Do you have to create 50 different “Read From Excel” actions?…

Copyright 2017 - Softomotive Ltd