Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DataGlobal Sheet
#2
Solved: 10 Years, 9 Months, 2 Weeks ago
Hi JeanFrederique
Following logic should help you
Code:
'get the row count of global sheet
rCount= datatable.GetSheet(dtGlobalsheet).GetRowCount
'use a for loop to iterate through all rows
For i = 1 to rCount
'set the current row of global sheet
Datatable.SetCurrentRow (i)
'set the message in your web edit
Browser("Yahoo!").Page("Twitter").WebEdit("message").Set DataTable("post", dtGlobalSheet)
Browser("Yahoo!").Page("Twitter").WebButton("update").Click
'Navigate back to your message posting page
Next

alternately you can iterate you message posting statements(only) through all the rows of global sheet by setting 'Run on all rows' at File . Settings, under Run Tab.

Reply


Messages In This Thread
DataGlobal Sheet - by JeanFrederique - 10-29-2009, 10:26 PM
RE: DataGlobal Sheet - by Saket - 10-30-2009, 09:46 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  export data from one sheet to another sheet in data table raaj123 1 2,198 05-21-2013, 02:21 PM
Last Post: Shahzaad
Question Is Local sheet different from Global sheet in DataTable... Goldy 6 4,938 10-08-2008, 02:08 AM
Last Post: Goldy

Forum Jump:


Users browsing this thread: 1 Guest(s)