Search found 38 matches

by brunop
Tue Jun 15, 2010 11:45 am
Forum: Technical / Scripting
Topic: Compare data grabbed from webpage
Replies: 3
Views: 3990

Hi there Iv been reading a lot about how to import data from excel. Would you say I should try and do it in VBScript since its already running in the script for other reasons or is it ok to mix in "DDERequest", "DBQuery" or other ways? I found this piece of code that gets a cell value but I cannot s...
by brunop
Sun Jun 13, 2010 2:35 pm
Forum: Beginners
Topic: Searching for several images using FindImagePos
Replies: 2
Views: 3920

Perfect just what I needed.

Bruno
by brunop
Sun Jun 13, 2010 2:14 pm
Forum: Technical / Scripting
Topic: Compare data grabbed from webpage
Replies: 3
Views: 3990

Compare data grabbed from webpage

Im looking for a way to compare and notify me if the same data/number is found when grabbing data from a webpage. Im using the tag extraction wizard to grab the data from a webpage, the data is called SPAN4. I would like to be able to see a list of all the grabbed and compared data when the script e...
by brunop
Sun Jun 13, 2010 1:02 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Thanks Adroege its running smoothly now and I have learned quite a bit about VBScripts and Scripting in general!

Ill probably end up with more questions later but then Ill start a new thread!

Thanks again

Bruno
by brunop
Sun Jun 13, 2010 11:04 am
Forum: Beginners
Topic: Searching for several images using FindImagePos
Replies: 2
Views: 3920

Searching for several images using FindImagePos

How do you make a script look for more than one picture? I know how to use the FindImagePos but if I want the script to look for first one picture and if that one is not found then look for another and so on and in the end if non of the pictures were found give me an error message and stop the scrip...
by brunop
Sun Jun 13, 2010 10:53 am
Forum: Beginners
Topic: How do you keep track of a large script?
Replies: 2
Views: 3823

Great CODEBLOCK was just the thing I was looking for :-)

Thanks!

Bruno
by brunop
Sat Jun 12, 2010 7:52 pm
Forum: Beginners
Topic: How do you keep track of a large script?
Replies: 2
Views: 3823

How do you keep track of a large script?

Im creating a script that is composed of a lot of segments, but those segments added up becomes a real pain to keep track of so I was wondering if there was a way to make it easier for me to comprehend the full script. Maybe being able to color each segment a different color or maybe just having a l...
by brunop
Fri Jun 11, 2010 12:55 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Hi again I have really tried to get this to work but after a few days I must once again ask for help. I have tried to add your suggestions but with no luck. My script is pasted in below, this is when I try to get info from 2 accounts to insert into Excel. I have basically just inserted the code to g...
by brunop
Mon Jun 07, 2010 6:34 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Hi again. I have testet the new script and its working flawlessly :-) I am really happy that you are taking the time to help me get going. I can see from the new script data you created that I would have been in way over my head on this one. I do have a few minor questions more :roll: If I want to a...
by brunop
Mon Jun 07, 2010 2:16 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

The new script looks like this: MouseMove>0,0 Let>delay=1 IE_Create>0,IE[0] // go to website IE_Navigate>%IE[0]%,http://neteller.com/,r IE_Wait>%IE[0]%,r Wait>delay // inserts secure id Let>FrameName={""} Let>FormName={"signInform"} Let>FieldName={"signInform:secureId"} Let>FieldValue={"xxxxx"} IE_F...
by brunop
Mon Jun 07, 2010 1:39 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Sure here it is MouseMove>0,0 Let>delay=1 IE_Create>0,IE[0] // go to website IE_Navigate>%IE[0]%,http://neteller.com/,r IE_Wait>%IE[0]%,r Wait>delay // inserts secure id Let>FrameName={""} Let>FormName={"signInform"} Let>FieldName={"signInform:secureId"} Let>FieldValue={"THIS IS SECRET"} IE_FormFill...
by brunop
Mon Jun 07, 2010 1:08 am
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Iv been playing around a bit with the codes you gave me and I finally got it to work! Im seeing real progress! I really appreciate you taking the time to help me! This will be a real timesaver when I get it to work! The script ended up looking like this: VBSTART Sub ExcelExample (mystring) Dim xlApp...
by brunop
Sat Jun 05, 2010 3:53 pm
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Great just what I needed, thanks Adroege I have now been playing around a bit with the excel script Marcus have made for entering data into excel (found here http://www.mjtnet.com/forum/viewtopic.php?t=1470) and that works fine but Im a bit lost on how to get the "SPAN12" data put into the excel she...
by brunop
Sat Jun 05, 2010 5:45 am
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Great im already getting further. Im using webrecorder to go to the correct page and log in. Then im using the tag extraction wizard to mark/get the text that I want to copy - in my scipt it looks like this //Modify buffer size if required ... Let>SPAN12_SIZE=4098 IE_ExtractTag>%IE[0]%,,SPAN,12,0,SP...
by brunop
Sat Jun 05, 2010 12:40 am
Forum: Technical / Scripting
Topic: Copying data from webpage and pasting it in an Excel sheet
Replies: 17
Views: 32969

Copying data from webpage and pasting it in an Excel sheet

Hi guys im hoping for a bit of help here. Im still quite new to this so go easy on me. Im trying to do a script that logs onto my Neteller account (an online payment system like Paypal) and extract my current balance and then place it correctly in an spreadsheet I have made in Excel. I have made a f...
Sign up to our newsletter for free automation tips, tricks & discounts