Excel Row count with AcvtiveX Script (DTS)

• Ram Kumar-226171

  Newbie

  Points: 9

  More actions

  January 16, 2009 at 1:10 am

  #71221

  After opening excel sheet how do I get the row counts on the opened worksheet.

  Please Note: I can't use SQL task to get the count.

  Dim ex_app

  Dim ex_wbook

  Dim ex_wksheet

  Dim sFilename

  sFilename = DTSGlobalVariables("gv_ExcelFilename").Value

  ' Create the Excel Object

  Set ex_app = CreateObject("Excel.Application")

  ' Open up the Excel Spreadsheet

  Set ex_wbook = ex_app.Workbooks.Open(sFilename)

  ' Which sheet do we get our data from

  Set ex_wksheet = ex_wbook.Worksheets(1)

  After this point, I couldn't proceed.

  Experts please shed some light on this.

  Thanks

  RK