10-30-2009, 09:46 AM
Hi JeanFrederique
Following logic should help you
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.
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.