WinAutomation - windows automation software with macro recorder
About Softomotive

      Using Data from Excel - Part II

      Posted by Thomas Minitsios on Fri, 01/29/2010 - 19:17

      In the first part of the "Using Data from Excel" blog post, we retrieved all the information from the Excel file and stored them in a data table variable called: %ExcelDataTable%. We also added a "Send Email" action that will send a single email to a specific recipient. In the second part of the blog post, we are going to create a Loop in order to send the email to every address in the xlsx file.

      Our job should look like this so far:

      Tags:  




      Using Data from Excel - Part I

      Posted by Thomas Minitsios on Fri, 01/29/2010 - 14:33

      After doing some research in our forum, I came across the same question multiple times: "How do I read all the information from an Excel file and then use it to send an email or fill a form?". I am writing this article to give you a step-by-step guide about how you can read all the information that are stored in an Excel worksheet, and use it to send customized emails to multiple recipients. So, let's get started!

      Tags:  




      How To - Modify the "Date Created" and "Date Modified" attributes of files

      Posted by Thomas Minitsios on Fri, 01/15/2010 - 15:58

      A couple of weeks ago, we have received the following support request from a WinAutomation user:

      "How can I change a file's modified date? I figured out how to get the modified date but can't figure out how to change it. Essentially I have a TIF and JPG file and I want to make the JPG have the same modified date as the TIF file."

      Tags:  




      Logical Operations in WinAutomation

      Posted by Thomas Minitsios on Fri, 01/15/2010 - 13:53

      Sometimes when you are creating a conditional, you may want to check if 2 conditions are simultaneously TRUE (or FALSE ). Some other times, you may want to execute a block of actions if at least one of the 2 conditions is true. WinAutomation allows you to perform basic logical operations with boolean variables. The logical connectives that are available in WinAutomation are the following:

      Negation (not): !
      Conjunction (and): &&
      Disjunction (or): ||

      Tags:  




      Send Multiple Repetitive Keystrokes with Send Keys

      Posted by Thomas Minitsios on Wed, 01/13/2010 - 23:55

      When automating form submissions with WinAutomation, it is usually needed to send the same keystroke multiple times. A typical example is the {Tab} keystroke which is used to change the input field that we are currently editing. For example, in the form that is shown below:


      you will have to send 11 Tab keystrokes in order to modify the "Distance from ground".

      Tags:  




      How To - Shorten URL With Hotkey

      Posted by Thomas Minitsios on Mon, 01/04/2010 - 22:07

      One of the tasks that almost everyone repeats daily is the URL shortening. Whenever we want to post a link in our twitter/facebook status, we usually follow the steps below:

      1) Select and copy the really long URL to the clipboard (Ctrl+C),
      2) Paste it in a shortening service's form,
      3) Hit the submit button,
      4) Wait for the service to return the short URL,
      5) Copy the short URL,
      6) Paste the short URL into our social networking site.

      Tags:  
      Featured Clients




      Monthly Blog Archive

      SUBSCRIBE TO OUR NEWSLETTER
      		 

      Follow Us on Twitter      Join us on Facebook

      © 2005-2009 - Softomotive - All rights reserved