Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excelsheet data entry
Not Solved
How to use code of attaching excel sheet so that it can take input from excel of desirable row and column and can also be able to put data to excel during run time .
Right now i am using this code but not able to take input from 2nd,3rd row n so on.....
Public Function GetInputFromExcel(InputFilePath,sheetName,VariableName)

set objExcel = createobject("excel.application")
set objWB = objExcel.workbooks.open (InputFilePath)
set objsheet = objwb.worksheets(sheetName)

For j = 1 to objsheet.usedrange.columns.count
If Ucase(objsheet.Cells(1,j).value) = Ucase(VariableName) Then
GetInputFromExcel = objsheet.Cells(2,j).value 
Exit For
End If

set objExcel=nothing

End Function
Jump to the post that solved this thread.

Possibly Related Threads...
Thread Author Replies Views Last Post
  Entry Certification diya 3 1,470 12-04-2012, 05:42 AM
Last Post: diya
  "1062 - Duplicate entry '557132' for key 1" while trying to register to Mercury Tour karankaruna 4 4,673 03-17-2011, 04:37 PM
Last Post: kodak
  use of a datatable but <enter> is needed after the 8th entry cocojava 1 1,424 10-15-2010, 10:07 PM
Last Post: supputuri
  Newbie: How do i count through a webtable to find an entry? jove1776 5 2,895 08-27-2010, 08:05 PM
Last Post: supputuri
  How to map Action TestResult with excelSheet test case? riteshgpt 1 1,522 05-02-2010, 12:18 AM
Last Post: basanth27

Forum Jump:

Users browsing this thread: 1 Guest(s)