tradertt Posted July 24, 2006 Share Posted July 24, 2006 Can anyone help me do this script?Excel file is here:http://www.upload2.net/page/download/yaWHh...ophelp.xls.html1) Excel Spreadsheet has a number of URLs inside listed2) Load the URLs inside3) Paste the Name, Email and URL inside and enter4) A page will appear with the textLink ExchangeThank you for submitting your link. It has been submitted for moderator approval and should show up shortly. You can start linking to us using this link: http://coinarcade.net/link.php?action=in&id=53 5) Paste the link http://coinarcade.net/link.php?action=in&id=53 back into excel just beside the URL loadedCan anyone help me do it?Thanks Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
tradertt Posted July 24, 2006 Author Share Posted July 24, 2006 Errr anyone can help on this? Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted July 24, 2006 Moderators Share Posted July 24, 2006 (edited) Errr anyone can help on this?How long did you try before you posted for help?Edit:Read my comment, seemed to read to be rude, wasn't meant to be so took it out. Edited July 24, 2006 by SmOke_N Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 No problem. I tried searching through the forum for each section that I need to do but there are a few parts which I cannot solve as I do know nothing about programming actually hehe ... which is why i thought I would post here as it should be relatively simple for someone with programming knowledge .. sad to say ... Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 Opt("WinWaitDelay",100) Opt("WinTitleMatchMode",4) WinActivate("Microsoft Excel") WinWait("Microsoft Excel") Send("{DOWN}{CTRLDOWN}c{CTRLUP}")This is the code for my excel to go down 1 line and copy.However, how do I add it as a variable into my IE.au3 code.#include <IE.au3> $o_IE = _IECreate () _IENavigate ($o_IE, "http://www.autoitscript.com/")How can I replace http://www.autoitscript.com to a variable which is the one copied in Excel? Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
win2k Posted July 25, 2006 Share Posted July 25, 2006 (edited) I think you are going to have to copy the variable to the clipboard and then use clipget() to retrieve it. send("^C") $variable=ClipGet() $IE_Addy=$variable I think that is how you would go about doing that Edited July 25, 2006 by win2k Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 #include <IE.au3> Dim $variable, $oIE, $o_IE Opt("WinWaitDelay",100) Opt("WinTitleMatchMode",4) WinActivate("Microsoft Excel") WinWait("Microsoft Excel") Send("{DOWN}{CTRLDOWN}c{CTRLUP}") $o_IE = _IECreate () $variable=ClipGet() $IE_Addy=$variable _IENavigate($oIE, "$variable") Cannot seem to be able to input the variable in. Was thinking about using Clipget too which should output the Clipboard into a Variable. But when I run the script, the variable was not pasted in. Anyone knows why ? Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
Skruge Posted July 25, 2006 Share Posted July 25, 2006 #include <IE.au3> Dim $variable, $oIE, $o_IE Opt("WinWaitDelay",100) Opt("WinTitleMatchMode",4) WinActivate("Microsoft Excel") WinWait("Microsoft Excel") Send("{DOWN}{CTRLDOWN}c{CTRLUP}") $o_IE = _IECreate () $variable=ClipGet() $IE_Addy=$variable _IENavigate($oIE, "$variable") Cannot seem to be able to input the variable in. Was thinking about using Clipget too which should output the Clipboard into a Variable. But when I run the script, the variable was not pasted in. Anyone knows why ?"$variable" is a string constant, not a variable. Remove the quotes.$o_IE <> $oIE. If you use Opt("MustDeclareVars",1) you would catch these errors. [font="Tahoma"]"Tougher than the toughies and smarter than the smarties"[/font] Link to comment Share on other sites More sharing options...
win2k Posted July 25, 2006 Share Posted July 25, 2006 you are going to use $IE_Addy in place of where you want to paste the URL and i dont think you need quotes around the variable name when you send it Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 #include <IE.au3> Dim $variable, $oIE, $o_IE, $IE_Addy Opt("WinWaitDelay",100) Opt("WinTitleMatchMode",4) WinActivate("Microsoft Excel") WinWait("Microsoft Excel") Send("{DOWN}{CTRLDOWN}c{CTRLUP}") $o_IE = _IECreate () $variable=ClipGet() _IENavigate($o_IE, $variable) My latest code - But 2 questions: 1) I get an error message when I run it though it runs fine and opens the webpage as it should 2) Just out of curiousity, why must we use $variable = $ie_addy Is this for clarity or can I just leave it as $variable? Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 ?Opt("MustDeclareVars",1) #include <IE.au3> Dim $variable, $oIE, $o_IE, $o_object Opt("WinWaitDelay",100) Opt("WinTitleMatchMode",4) WinActivate("Microsoft Excel") WinWait("Microsoft Excel") Send("{DOWN}{CTRLDOWN}c{CTRLUP}") $o_IE = _IECreate () $variable=ClipGet() _IENavigate($o_IE, $variable) When I put in the OPT( must declare vars code It seems that it keeps giving me Undeclared variables errors from IE.au3 Why is this so? How can I get around this? Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
DaleHohm Posted July 25, 2006 Share Posted July 25, 2006 (edited) It doesn't look to me that you are using the latest version of IE.au3. Please install the most recent beta of AutoIt and it will be installed for you. The variable $s_oname does not appear anywhere in the latest version and all of my variables are declared. _IE_VersionsInfo() will show you the IE.au3 version in the SciTe console. Should be T2.0-5 or higher. Dale Edit: and you should find IE.au3 in ...\AutoIt\beta\include not ...\AutoIt\include Edited July 25, 2006 by DaleHohm Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
tradertt Posted July 25, 2006 Author Share Posted July 25, 2006 Thanks it works ... I installed BETA in - I think it was running from the original folder ThanksI have got a question, if I got a page like this, http://www.arcadecity.net/index.php?page=l...de&submit=1How can I output the http://www.arcadecity.net/link.php?action=in&id=122 into a text file or a excel spreadsheet - Free Flash Games Online | Car Modifications Articles | Free Arcade Games Online Link to comment Share on other sites More sharing options...
DaleHohm Posted July 25, 2006 Share Posted July 25, 2006 I have got a question, if I got a page like this, http://www.arcadecity.net/index.php?page=l...de&submit=1How can I output the http://www.arcadecity.net/link.php?action=in&id=122 into a text file or a excel spreadsheet -I don't see anything the that link on the page you provided.Dale Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now