How to keep loading data until a row is blank?

Getting started -basics for starting with WinTask

How to keep loading data until a row is blank?

Postby Yasir on Tue Jun 10, 2014 7:23 am

We want to automate the process we have setup to enter new members into a web form on a daily basis. We will be running a script that extracts all new members from our database with an API. They will go into a spreadsheet. We then want to auto mate the script that then loads them all into a web form.

The issue we will face is not knowing how many new members per day. In the script to load them into the web form it appears we need to put in a range per field. Is there syntax that allows it to keep loading until a row is blank?
Yasir
 
Posts: 18
Joined: Tue Jun 21, 2005 5:18 pm

Re: How to keep loading data until a row is blank?

Postby TechSupport on Thu Jun 12, 2014 9:29 am

Hello,
I will suppose that in your spreadsheet, you have only the new members. Then you do a ReadExcel using a big range, so if you can have a maximum of 100 new members, use A1:A100, and then in your loop to populate the web form you can repeat until newmember$(i)=””

This video explains how looping until a cell is empty:
http://www.wintask.com/tutorials/exceld ... part2.html

Regards.
WinTask Tech Support
TechSupport
 
Posts: 805
Joined: Thu Nov 16, 2006 9:58 am


Return to Getting started

Who is online

Users browsing this forum: No registered users and 1 guest

cron