'To get row count of excel sheet
'path = path of .xls file (c:/test.xls)
'sheet is the name of workbook sheet
function get_row_count(path,sheet)
dim inputdata
dim rowc
set inputData = DDT.ExcelDriver(path, Sheet)
while not inputdata.EOF
inputdata.Next
rowc = rowc+1
Wend
get_row_count = rowc
end Function
Hi,
ReplyDeletethis method was useful. I need to know how to update an excel field using DDT ExcelDriver. kindly share me the solution if you have faced this problem.
Thanks
Chan
Great and I have a tremendous proposal: Does Renovation Increase House Value home kitchen renovation
ReplyDelete