Read Excel Worksheet Cell Value

[jfcby]

Hello,

I'm working with an Excel Worksheet where I need to read cell values and store them in a varible to use in the script.

Is there a way to check if the workbook open?

Can the following script be modified to read cell values if the workbook is already open?

#include <Excel.au3>

$sFilePath1 = "C:\Documents and Settings\User\Desktop\ScriptProect\FFPM\Equip_List_FF.xls"
$oExcel = _ExcelBookOpen($sFilePath1)

Sleep(2000)

$sCellValue = _ExcelReadCell($oExcel, 4, 1)
MsgBox(0, "", "The Cell Value is: " & @CRLF & $sCellValue, 2)

Thank you for your help,

jfcby

[PsaltyDS]

Hello,

I'm working with an Excel Worksheet where I need to read cell values and store them in a varible to use in the script.

Is there a way to check if the workbook open?

Can the following script be modified to read cell values if the workbook is already open?

#include <Excel.au3>

$sFilePath1 = "C:\Documents and Settings\User\Desktop\ScriptProect\FFPM\Equip_List_FF.xls"
$oExcel = _ExcelBookOpen($sFilePath1)

Sleep(2000)

$sCellValue = _ExcelReadCell($oExcel, 4, 1)
MsgBox(0, "", "The Cell Value is: " & @CRLF & $sCellValue, 2)

Thank you for your help,

jfcby

In the UDF: _ExcelAttach()

Updated function from big_daddy: _ExcelBookAttach()