hello,
i tried first to import the sheet but could not proceed..the code is,i always get failed
i have an excel with username and password and trying to check to add new column if exists add value if not add column and value...please help
i tried first to import the sheet but could not proceed..the code is,i always get failed
i have an excel with username and password and trying to check to add new column if exists add value if not add column and value...please help
Code:
'datatable.ImportSheet "C:\Documents and Settings\Administrator\Desktop\excelblank.xls",1,"Action1"
'paramcount=datatable.GetSheet("Action1").GetParameterCount
'msgbox paramcount
'For i=1 to paramcount
' If (datatable.Value(i,"Action1")="Password") then
' msgbox "passed"
' else
' msgbox "failed"
'end if
'
'Next