Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: rowcount
cellval = DDERequest (channel2, "R3C2") Check the value and then change the cell number to get an another one.Thank for any suggestion.
;illustrates getting rowcount from Excel Database cConn = "Provider=MicroSoft.Jet.OLEDB.4.0; Data Source=e:\wbdemo\test.xls; Extended Properties=Excel 5.0;" DB = ObjectOpen("ADODB.Connection") DB.Open(cConn) RS = DB.Execute("SELECT COUNT(*) FROM RAO AS CNT") RS.MoveFirst() ;may not even be necessary fld = RS.Fields(0) v = fld.Value message("Number of Rows, Excluding Headings",v-1) DB.Close() ObjectClose(DB) exit
Article ID: W14697
Filename: Getting Rowcount from Excel Database.txt
File Created: 2000:07:17:11:39:36
Last Updated: 2000:07:17:11:39:36