Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excelsheet data entry
#1
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")
objExcel.DisplayAlerts=false
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
Next

objWb.save
objWB.close
objExcel.Quit
set objExcel=nothing

End Function
Reply
Jump to the post that solved this thread.


Possibly Related Threads…
Thread Author Replies Views Last Post
  Entry Certification diya 3 2,578 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 5,856 03-17-2011, 04:37 PM
Last Post: kodak
  use of a datatable but <enter> is needed after the 8th entry cocojava 1 2,158 10-15-2010, 10:07 PM
Last Post: supputuri
  Newbie: How do i count through a webtable to find an entry? jove1776 5 4,392 08-27-2010, 08:05 PM
Last Post: supputuri
  How to map Action TestResult with excelSheet test case? riteshgpt 1 2,298 05-02-2010, 12:18 AM
Last Post: basanth27

Forum Jump:


Users browsing this thread: 1 Guest(s)