05-03-2012, 05:56 PM
thanku for the reply i tried and get the code
Code:
set camptable=browser("title:=Campaign Framework:.*").page("title:=Campaign Framework: Home ~ salesforce.com - Unlimited Edition").webtable("column names:=Campaign Name;Status;Start Date","html tag:=TABLE")
c=camptable.GetROProperty("rows")
For i=2 to c
a=camptable.getcelldata(i,1)
row=DataTable.GetSheet("Global").getCurrentRow
datatable.getsheet("Global").SetCurrentRow(row)
datatable.Value("id","Global")=a
datatable.getsheet("Global").SetCurrentRow(row+1)
datatable.Export "c:\test11.xls"
next