Sign in to follow this  
Followers 0

google

13 posts in this topic

#1 ·  Posted

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)

google.au3

Share this post


Link to post
Share on other sites



#2 ·  Posted

Remove the "_" from the WinWaitActive calls.


My UDFs and Tutorials:

UDFs:
Active Directory (NEW 2015-08-07 - Version 1.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (NEW 2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

Share this post


Link to post
Share on other sites

#3 ·  Posted

it do not solve the problem

Share this post


Link to post
Share on other sites

#4 ·  Posted

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?


My UDFs and Tutorials:

UDFs:
Active Directory (NEW 2015-08-07 - Version 1.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (NEW 2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

Share this post


Link to post
Share on other sites

#5 ·  Posted

#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 ---


[size="5"] [/size]

Share this post


Link to post
Share on other sites

#6 ·  Posted

#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.


 

.

eMyvnE

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

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

Edited by Mat

Share this post


Link to post
Share on other sites

#8 ·  Posted

@@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.


[size="5"] [/size]

Share this post


Link to post
Share on other sites

#9 ·  Posted

@@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.


 

.

eMyvnE

Share this post


Link to post
Share on other sites

#10 ·  Posted

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

Share this post


Link to post
Share on other sites

#11 ·  Posted

i have a new script and it works thankx to all

now i need to loop it

Share this post


Link to post
Share on other sites

#12 ·  Posted

help it dosnt work and i need it urgent ;)

Share this post


Link to post
Share on other sites

#13 ·  Posted

solved

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  
Followers 0