IECreate not working using Excelsheet values

[orichec]

Hello,

I'm trying to save source of a particular webpage using its URL. When i tried to save source code using following command it works fine

$IE = _IECreate( 'www.example.com', 0, 0 )

But my problem is different I've saved different URL in my excel sheet, that's why, I tried to use "$IE" command in this way;

$URL = _Excel_RangeCopyPaste($oWorkbook1.Activesheet, "C1")
$IE = _IECreate($URL, 0, 0 )

But It's unable to fetch source codes using URL placed in excel sheet 1 at cell No. "C1".

Please guide me what's wrong with my codes and how can I make it possible to use URL placed in excel sheet instead of copying URL every time in "_IECreate" command.

Thanks

#RequireAdmin
#include <Excel.au3>
#include <IE.au3>
#include <String.au3>
#include <Array.au3>
Local $oExcel = _Excel_Open()
Local $oWorkbook1 = _Excel_BookOpen($oExcel, @ScriptDir & "\Software.csv", True)
$file = fileopen(@scriptdir & "\source01.txt", 10)
;------------Below Command is not working---------------------
$URL = _Excel_RangeCopyPaste($oWorkbook1.Activesheet, "C1"
;------------String $IE unable to fetch data from URL available in excel sheet at cell No. "C1"---------------------
$IE = _IECreate($URL, 0, 0 )
$source = _IEDocReadHTML($IE)
FileWrite($file, $source)

 

Edited March 4, 2016 by orichec

[MuffinMan]

Try replacing your _ExcelRAngeCopyPaste line with this:

$URL = _Excel_RangeRead ($oWorkbook1, Default, "C1")

Make use of Msgbox to display your variables and it will help you troubleshoot any issues you are having.

[AutoBert]

Your script isn't runable:

>Running AU3Check (3.3.14.2)  from:C:\Program Files\AutoIt3  input:C:\Users\Bert\AutoIt3.My\Temp\aa.au3
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(9,59) : error: syntax error
$URL = _Excel_RangeCopyPaste($oWorkbook1.Activesheet, "C1"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(11,21) : warning: $URL: possibly used before declaration.
$IE = _IECreate($URL,
~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(11,29) : error: syntax error
$IE = _IECreate($URL, 0, 0 )
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(12,29) : warning: $IE: possibly used before declaration.
$source = _IEDocReadHTML($IE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(12,30) : error: syntax error
$source = _IEDocReadHTML($IE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(13,25) : warning: $source: possibly used before declaration.
FileWrite($file, $source)
~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(12,29) : error: $IE: undeclared global variable.
$source = _IEDocReadHTML($IE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
"C:\Users\Bert\AutoIt3.My\Temp\aa.au3"(13,25) : error: $source: undeclared global variable.
FileWrite($file, $source)
~~~~~~~~~~~~~~~~~~~~~~~~^
C:\Users\Bert\AutoIt3.My\Temp\aa.au3 - 5 error(s), 3 warning(s)
!>16:31:31 AU3Check ended. Press F4 to jump to next error.rc:2
+>16:31:31 AutoIt3Wrapper Finished.
>Exit code: 2    Time: 1.222

but why using excel when URL is in a CSV-File? This can be read by native AutoIt.

[orichec]

2 hours ago, MuffinMan said:

Try replacing your _ExcelRAngeCopyPaste line with this:

$URL = _Excel_RangeRead ($oWorkbook1, Default, "C1")

Make use of Msgbox to display your variables and it will help you troubleshoot any issues you are having.

Thanks mate, it works for me....