Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

google


  • Please log in to reply
12 replies to this topic

#1 notjes

notjes

    Seeker

  • Active Members
  • 11 posts

Posted 21 June 2010 - 09:11 AM

i need to search 22636 programs in google i have a excel file and i wanna to copy the text to google to search what it is

then i need the first link and paste it into excel

i have a script with macrorecorder buth it is not working

i have this error

D:\werk\google.au3(20,1) : ERROR: syntax error (illegal character)
"
^
D:\werk\google.au3(2,55) : ERROR: _WinWaitActivate(): undefined function.
_WinWaitActivate("D:\werk\google.au3 * SciTE","Source")
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
D:\werk\google.au3 - 2 error(s), 0 warning(s)

Attached Files









#2 water

water

    ?

  • MVPs
  • 15,540 posts

Posted 21 June 2010 - 09:14 AM

Remove the "_" from the WinWaitActive calls.
UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

#3 notjes

notjes

    Seeker

  • Active Members
  • 11 posts

Posted 21 June 2010 - 10:11 AM

it do not solve the problem

#4 water

water

    ?

  • MVPs
  • 15,540 posts

Posted 21 June 2010 - 10:14 AM

The error message says that "_WinWaitActive" is an undefined function. Change it to "WinWaitActivate" and your script should run fine because this is a genuine AutoIt function.
If it doesn't work could you please post the error messages?
UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

#5 Fire

Fire

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 364 posts

Posted 21 June 2010 - 10:16 AM

AutoIt         
#region --- Au3Recorder generated code Start --- _WinWaitActivate("D:\werk\google.au3 * SciTE","Source") MouseClick("left",689,1045,1) _WinWaitActivate("Microsoft Excel - allsoftware.xls [Compatibiliteitsmodus]","allsoftware.xls [Co") MouseClick("left",89,260,1) Send("{CTRLDOWN}c{CTRLUP}") MouseClick("left",365,1044,1) _WinWaitActivate("Google - Mozilla Firefox","") MouseClick("left",176,67,1) Send("{CTRLDOWN}v{CTRLUP}{ENTER}") _WinWaitActivate("Christmas Sleigh Ridess - Google zoeken - Mozilla Firefox","") MouseClick("left",332,309,1) _WinWaitActivate("Sleigh Ride - Wikipedia, the free encyclopedia - Mozilla Firefox","") MouseClick("left",323,64,1) Send("{CTRLDOWN}c{CTRLUP}") _WinWaitActivate("Program Manager","FolderView") MouseClick("left",653,1037,1) _WinWaitActivate("Microsoft Excel - allsoftware.xls [Compatibiliteitsmodus]","allsoftware.xls [Co") Send("{RIGHT}{RIGHT}{CTRLDOWN}v{CTRLUP}{DOWN}{LEFT}{LEFT}") ;") <= #region --- Internal functions Au3Recorder Start --- Func _WinWaitActivate($title,$text,$timeout=0)     WinWait($title,$text,$timeout)     If Not WinActive($title,$text) Then WinActivate($title,$text)     WinWaitActive($title,$text,$timeout) EndFunc #endregion --- Internal functions Au3Recorder End --- #endregion --- Au3Recorder generated code End --- #endregion --- Au3Recorder generated code End ---


#6 trancexx

trancexx

    Queen F. Elizabeth MCXI

  • Active Members
  • PipPipPipPipPipPip
  • 6,246 posts

Posted 21 June 2010 - 10:29 AM

AutoIt         
#region --- Au3Recorder generated code Start --- _WinWaitActivate("D:\werk\google.au3 * SciTE","Source") MouseClick("left",689,1045,1) _WinWaitActivate("Microsoft Excel - allsoftware.xls [Compatibiliteitsmodus]","allsoftware.xls [Co") MouseClick("left",89,260,1) Send("{CTRLDOWN}c{CTRLUP}") MouseClick("left",365,1044,1) _WinWaitActivate("Google - Mozilla Firefox","") MouseClick("left",176,67,1) Send("{CTRLDOWN}v{CTRLUP}{ENTER}") _WinWaitActivate("Christmas Sleigh Ridess - Google zoeken - Mozilla Firefox","") MouseClick("left",332,309,1) _WinWaitActivate("Sleigh Ride - Wikipedia, the free encyclopedia - Mozilla Firefox","") MouseClick("left",323,64,1) Send("{CTRLDOWN}c{CTRLUP}") _WinWaitActivate("Program Manager","FolderView") MouseClick("left",653,1037,1) _WinWaitActivate("Microsoft Excel - allsoftware.xls [Compatibiliteitsmodus]","allsoftware.xls [Co") Send("{RIGHT}{RIGHT}{CTRLDOWN}v{CTRLUP}{DOWN}{LEFT}{LEFT}") ;") <= #region --- Internal functions Au3Recorder Start --- Func _WinWaitActivate($title,$text,$timeout=0)     WinWait($title,$text,$timeout)     If Not WinActive($title,$text) Then WinActivate($title,$text)     WinWaitActive($title,$text,$timeout) EndFunc #endregion --- Internal functions Au3Recorder End --- #endregion --- Au3Recorder generated code End --- #endregion --- Au3Recorder generated code End ---

Do you know how much damage script(s) like that can do?
Au3Recorder thing should be wiped out from anything related to AutoIt.
Disaster.

          ......       ......
        .:oOOOOo:.   .:oOOOOo:.
      .:oOO:'':Oo:. .:oO:'':OOo:.
     .:oO:      'Oo:oO'      :Oo:.
     :oO:         'o'   
      :Oo:
     :oO:                     :Oo:
     ':oO:     OT9AO0IEDrk   :Oo:'
      ':oO:                 :Oo:'
        ':oO.             .Oo:'
          ':oO
.         .Oo:'
            ':oO.     .Oo:'
              ':oO. .Oo:'
                'oO:Oo'
                  'o' :kiss:



 

.
eMyvnE


#7 Mat

Mat

    43 38 48 31 30 4E 34 4F 32

  • MVPs
  • 5,066 posts

Posted 21 June 2010 - 10:37 AM

There is the Excel UDF, and a Firefox (FF) UDF. Use those to get more accurate and background automation.

Edited by Mat, 21 June 2010 - 10:37 AM.


#8 Fire

Fire

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 364 posts

Posted 21 June 2010 - 11:06 AM

@@trancexx

Yes i know.
This is not my script.It is notjes script.
Download it CTRL+F5 and you can see at line 20 ") .
In my post i just comment it.

#9 trancexx

trancexx

    Queen F. Elizabeth MCXI

  • Active Members
  • PipPipPipPipPipPip
  • 6,246 posts

Posted 21 June 2010 - 11:23 AM

@@trancexx

Yes i know.
This is not my script.

Good.

@notjes, I hope you will change at least two things regarding your AutoIt experience after this thread.

          ......       ......
        .:oOOOOo:.   .:oOOOOo:.
      .:oOO:'':Oo:. .:oO:'':OOo:.
     .:oO:      'Oo:oO'      :Oo:.
     :oO:         'o'   
      :Oo:
     :oO:                     :Oo:
     ':oO:     OT9AO0IEDrk   :Oo:'
      ':oO:                 :Oo:'
        ':oO.             .Oo:'
          ':oO
.         .Oo:'
            ':oO.     .Oo:'
              ':oO. .Oo:'
                'oO:Oo'
                  'o' :kiss:



 

.
eMyvnE


#10 EnderWiggin

EnderWiggin

    Seeker

  • Active Members
  • 24 posts

Posted 21 June 2010 - 11:25 AM

Do you know how much damage script(s) like that can do?
Au3Recorder thing should be wiped out from anything related to AutoIt.
Disaster.


I'm trying to learn autoit. Have read all the ebooks posted here and am working through youtube tutorials and such with little coding background. I often see comments like this one, 'do you know how much damage this can do,' or whatnot, and I have no idea what the author means. I'm currently working on doing something quite similar. Am I doing any harm? If so, and you could explain why, I'd much appreciate it. I don't want to accidentally create something malicious when I intend only to make my interaction with my computer less rote and more intelligent. Thank you

#11 notjes

notjes

    Seeker

  • Active Members
  • 11 posts

Posted 21 June 2010 - 12:46 PM

i have a new script and it works thankx to all

now i need to loop it

#12 notjes

notjes

    Seeker

  • Active Members
  • 11 posts

Posted 26 August 2010 - 07:42 AM

help it dosnt work and i need it urgent ;)

#13 notjes

notjes

    Seeker

  • Active Members
  • 11 posts

Posted 27 August 2010 - 08:07 AM

solved




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users