Jump to content
Sign in to follow this  
orichec

IECreate not working using Excelsheet values

Recommended Posts

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 by orichec

Share this post


Link to post
Share on other sites
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.

  • Like 1

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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....

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • Ahmed101
      By Ahmed101
      I have more than 12 workbooks opened together, if i wanted to attach to the last workbook opened it will take more than 1 minute !
      Is there any solution for that ?
    • Daniza
      By Daniza
      Hello! where should I start, if I want to have a Progress Bar while waiting for my File to be open, can I use WinWaitActive? Thanks,
    • Evolutionnext
      By Evolutionnext
      I am still a noob and not a programmer, would greatly appreciate your help.
       
      Task:
      Open Excel file with file path and name: C:\Users\GENOBEAUTYPC1\Desktop\ACTIVE BEAUTY LABELS\BeautyMe Label 200ml ACTIVE VERSION.xlsx
      This file path and name is saved in the variable: $sAnswer
      Go to Excel Tab called "formular"
      Go to Cell A1
      Insert the text saved in the variable: $sAnswer2
      ATTENTION!!! This has 2 problems.
      Problem number 1: This text contains special characters that need to be interpreted as raw text. (content is: Gemischt für#30 ml#Mindestens haltbar bis#Maria Wallerstorfer#Anwendung: Täglich 1x morgens auf das gereinigte Gesicht auftragen. Augenkontakt vermeiden.#Über 0 C° und unter 25 C° lagern.#Lot:N8A1028/D30/V2.1#Genome Plus GmbH#Georg-Wrede-St. 13, D-83395 Freilassing#GEN SERUM#DAY)
      Problem number 2: This textis longer than 255 characters.
       
      Can anyone help me?
       
      I try to do it really primitively by opening the excel, waiting until it is open, clicking where the tab is, clicking where the cell is and inserting the content of the variable, but I am stuck at the point where I am limited by 255 characters.
       

      ; Opening the right excel FileChangeDir
                  tooltip("File exists and is called:"&$sAnswer ,300,300)
                  ShellExecute($sAnswer ,"" ,"" ,"" , @SW_MAXIMIZE)
                  sleep(7000)
                  
                  tooltip("Now lets insert the right content into the excel",300,300)
                  MouseClick("left",226,1004)
                  MouseClick("left",52,179)
                  sleep(500)
                  Send("A1")
                  sleep(500)
                  send("{enter}")
                              tooltip("inserting label content",300,300)
                  sleep(500)
                  Send($sAnswer2,  1)
                                          tooltip("inserting INCIS",300,300)
                  sleep(5000)
                  Send($sAnswer3, 1)
                  sleep(5000)
       
       
       
    • AzgarD
      By AzgarD
      Hi guys. I know this is a newbie topic, very newbie, but i've read a lot of stuff and still don't get it. I just need to copy something from Excel cell, paste this in other program, copy something in this program and paste in other Excel cell. Something like...
      Copy A2 Use some WindowActivate and MouseMove stuff and CTRL+C (not a problem) Go back to the Excel sheet Paste that content in C2 Then Copy A3 Use some WindowActivate and MouseMove stuff and CTRL+C (not a problem) Go back to the Excel sheet Paste that content in C3 ... And it goes on The problem is, how can i "communicate" with Excel and do this row change? Like A2 to C2 and A3 to C3 ... In a efficient way that can be done like hundreds of times.
      Very newbie question but still not understanding this.
       
      Ty guys.
    • Gowrisankar
      By Gowrisankar
      Dear members of the forum,
      I need to open excel files that may or may not need a password and finally move the files that needs password to manual queue.
      Is there a fastest way to do this?
       
      PS: I have a huge respect for the rules of this forum. I am not asking assistance to override any security measure. I just need to segregate the files that needs passwords.
×