unable to copy cell value to clipboard

[wasimwsm 0]

hi

i want to copy cell values from clipboard but i m not able to doing so my code is like follows

#Include <Excel.au3>
Local $oExcel=("c:\wsm.xls")
_ExcelBookOpen($oExcel)
WinActivate("Microsoft Excel - wsm")
$sCellValue = 
_ExcelReadCell($oExcel,6,6 )
MsgBox(0, "", "The Cell Value is: " & @CRLF & $sCellValue, 2)

[enaiman 14]

WinActivate("Microsoft Excel - wsm") seem to be useless in your code.

And this:

Local $oExcel=("c:\wsm.xls")
_ExcelBookOpen($oExcel)

is completely wrong if you intend $oExcel to be the object referrence; you still need to read about the functions you are trying to use. (that's the purpose of a help file)

_ExcelBookOpen is returning the object ref so the code should be changed to:

Local $MyExcel=("c:\wsm.xls")
$oExcel = _ExcelBookOpen($MyExcel)

Edited August 4, 2010 by enaiman

[wasimwsm 0]

thanx enaiman for reply but how can i copy the cell to clipboard plz help me

[enaiman 14]

Did you try to fix your code the way I showed you? If you did, you should be able to read whatever is in that cell.