15 Sep 2010 - 03:43:45 pm
Code to get the Row & COlumn count in Excel
Set objExcel =
CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open (fileName)
Set objSheet = objExcel.ActiveWorkbook.Worksheets(1)
usedColumnsCount = objSheet.UsedRange.Columns.Count
usedRowsCount = objSheet.UsedRange.Rows.Count
Set objWorkbook = objExcel.Workbooks.Open (fileName)
Set objSheet = objExcel.ActiveWorkbook.Worksheets(1)
usedColumnsCount = objSheet.UsedRange.Columns.Count
usedRowsCount = objSheet.UsedRange.Rows.Count
2008-11-20 @ 12:41:11 pm
by venugopal
there are many problems we will ...
2008-07-16 @ 03:58:49 pm
by Ramu
what r the challenges have faced ...
2008-07-15 @ 10:57:24 am
by veerachary
attached the answers of the above ...
2008-07-10 @ 04:38:52 pm
by Ramu
Can you please provide the answers ...
2008-07-10 @ 04:07:58 pm
by chakri