need help in getting reading data from excel and then to firefox

[GauravM]

hi, I need help in understanding how I can read data from excel and pass it on to Mozilla firefox. the data i need to get from excel is url,

username and password.  tried below code but not sure about it.

#include <Excel.au3>

Local $oExcel = _Excel_BookOpen(@ScriptDir & "workbookinfo.xlsx", 0, 0)

 

$sCellValue = _Excel_RangeRead($oExcel, "B2")

$sCellValue2 = _Excel_RangeRead($oExcel, "C2")

$sCellValue3 = _Excel_RangeRead($oExcel, "D2")

 

$FF = @ProgramFilesDir & "Mozilla Firefoxfirefox.exe"

 

If FileExists($FF) Then

 

<stuck here> ?????

 

 

Else

 

MsgBox ($IDOK (1),"","no Firefox in this machine")

 

EndIf

Edited July 2, 2014 by GauravM

[GauravM]

also tried this code, not sure how i can capture value from excel and pass it  as URL and login info in browser 

#include <Excel.au3>

Local $oExcel = _Excel_BookOpen(@ScriptDir & "workbookinfo.xlsx", 0, 0)

 

$sCellValue = _Excel_RangeRead($oExcel, "B2")

$sCellValue2 = _Excel_RangeRead($oExcel, "C2")

$sCellValue3 = _Excel_RangeRead($oExcel, "D2")

 

 

ShellExecute(@ProgramFilesDir & "Mozilla Firefoxfirefox.exe",$sCellValue,"","open",@SW_HIDE)

[water]

A backslash is missing, _Excel_Open is missing and _Excel_BookOpen needs an additional parameter.

Be aware that with AutoIt 3.3.12.0 a fully rewritten Excel UDF is being provided. Function names AND parameters have changed.

Local $oExcel = _Excel_Open()
Local $oBook = _Excel_BookOpen($oExcel, @ScriptDir & "\workbookinfo.xlsx", 0, 0)

[GauravM]

Thank you sir  

[water]