Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Size of an EXCEL spreadsheet
cellval = DDERequest (channel2, "R3C2")
Check the value and then change the cell number to get an another one.
Thanks for any suggestions.
If the spreadsheets have databases as assigned 'ranges', you can use OLE and read the Rows in as a RecordSet, then use RowCount(), and perform a simple loop to get the Column Names.
;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: W14700
Filename: Size of an EXCEL spreadsheet.txt
File Created: 2000:06:30:12:18:04
Last Updated: 2000:06:30:12:18:04