Search found 100 matches

by ocnuybear
Mon Sep 03, 2018 10:10 am
Forum: Technical / Scripting
Topic: [Solved] Limit on positioning Dialogs?
Replies: 3
Views: 2710

[Solved] Limit on positioning Dialogs?

I have two identical FHD monitors with my main screen on the left, I'm trying to create a dialog on the second screen (right screen), but it can only move up till the end of the first screen and as soon as the Left X value is close to 1920, it jumps back to the start of the left screen, is there a l...
by ocnuybear
Mon Sep 03, 2018 8:33 am
Forum: Beginners
Topic: I have 2 questions i hope you guys help me with
Replies: 18
Views: 11735

Re: I have 2 questions i hope you guys help me with

Where did you get the 'fuel.PNG' file from? Also make sure you have used the correct path to the image file. Can you please try and capture the file with the Image Capture Tool under Tools menu, 7th option from the top? MS is very sensitive with the images it finds and must be created with this tool...
by ocnuybear
Mon Sep 03, 2018 7:05 am
Forum: Beginners
Topic: I have 2 questions i hope you guys help me with
Replies: 18
Views: 11735

Re: I have 2 questions i hope you guys help me with

Try this code: Let>x=0 Let>Timeout=10 While>x<%Timeout% Let>x=x+1 FindImagePos>C:\Users\x\Desktop\fuel.PNG,SCREEN,0.7,1,XArr,YArr,NumFound,CCOEFF If>NumFound>0 Let>x=%Timeout% MouseMove>XArr_0,YArr_0 LClick //Input>,Image found at Center of this Location,X=%XArr_0% Y=%YArr_0% EndIf EndWhile If>NumFo...
by ocnuybear
Wed Aug 22, 2018 3:04 pm
Forum: General Discussion
Topic: [Solved] the specified module could not be found: ocr.dll
Replies: 2
Views: 3399

Re: [Solved] the specified module could not be found: ocr.dll

Thank you Marcus, re-installing MS solved the issue :D
by ocnuybear
Wed Aug 22, 2018 1:57 pm
Forum: General Discussion
Topic: [Solved] the specified module could not be found: ocr.dll
Replies: 2
Views: 3399

[Solved] the specified module could not be found: ocr.dll

When using the Screen OCR Wizard, just after selecting an area on the screen it comes up with this message and MS completely crashes. Do we need to install a 3rd party OCR tool or library?
by ocnuybear
Wed Aug 15, 2018 8:47 am
Forum: General Discussion
Topic: Can Microsoft OLEDB Source be inputted directly from variable contents?
Replies: 8
Views: 6064

Re: Can Microsoft OLEDB Source be inputted directly from variable contents?

Thank you Marcus, I realize this is a Microsoft constraint, just asked you guys as you are the experts :D
by ocnuybear
Tue Aug 14, 2018 4:11 pm
Forum: General Discussion
Topic: Can Microsoft OLEDB Source be inputted directly from variable contents?
Replies: 8
Views: 6064

Re: Can Microsoft OLEDB Source be value from a string?

My apologies if my question is not clear, let me try again. I have a raw file like this: Save Time :2018-08-13 10:30:05 Time Names 13-08-18 5:00 Name7 13-08-18 5:00 Name5 13-08-18 5:00 Name3 13-08-18 5:00 Name4 13-08-18 5:00 Name2 13-08-18 5:00 Name6 13-08-18 5:00 Name1 13-08-18 5:00 Name8 13-08-18 ...
by ocnuybear
Tue Aug 14, 2018 11:24 am
Forum: General Discussion
Topic: Can Microsoft OLEDB Source be inputted directly from variable contents?
Replies: 8
Views: 6064

Re: Can Microsoft OLEDB Source be value from a string?

I actually want to run this without using Excel & it must be running in the background without any windows popping up.

I guess the way I'm already running it is the best solution for my requirements?

Also passing a variable's contents to OLEDB is not possible?
by ocnuybear
Tue Aug 14, 2018 5:46 am
Forum: General Discussion
Topic: Can Microsoft OLEDB Source be inputted directly from variable contents?
Replies: 8
Views: 6064

Re: Can Microsoft OLEDB Source be value from a string?

I have a raw CSV file like this - it has about 3000+ rows: Save Time :2018-08-13 10:30:05 Time Names 13-08-18 5:00 Name7 13-08-18 5:00 Name5 13-08-18 5:00 Name3 13-08-18 5:00 Name4 13-08-18 5:00 Name2 13-08-18 5:00 Name6 13-08-18 5:00 Name1 13-08-18 5:00 Name8 13-08-18 5:00 Name10 13-08-18 5:00 Name...
by ocnuybear
Mon Aug 13, 2018 7:22 am
Forum: General Discussion
Topic: Can Microsoft OLEDB Source be inputted directly from variable contents?
Replies: 8
Views: 6064

Can Microsoft OLEDB Source be inputted directly from variable contents?

I'm using Microsoft.Jet.OLEDB in my macro and before loading data into this database I need to do some cleanup and get the headers into the first line, then save it as a file. Then this file is loaded into Microsoft.Jet.OLEDB. Now my question is it takes time to load and save strings to files, so I ...
by ocnuybear
Fri Aug 03, 2018 10:34 am
Forum: Scripts and Tips
Topic: Mouse Cursor Control
Replies: 0
Views: 9366

Mouse Cursor Control

Say you want to see where the mouse cursor has moved to - you can use this script to move the mouse on a small area or make the mouse move in a box form with starting coordinates, Width & Height and speed. Script can also be used for mouse move animation if needed moving in a small square. This scri...
by ocnuybear
Thu Aug 02, 2018 9:25 am
Forum: Beginners
Topic: [Solved] Sending CTRL+F to Chrome is working intermittently
Replies: 2
Views: 2664

Re: [Solved] Sending CTRL+F to Chrome is working intermittently

Seems like the Wait>0.1 is not playing any role here, script works consistently without it,
by ocnuybear
Thu Aug 02, 2018 9:18 am
Forum: Beginners
Topic: [Solved] Sending CTRL+F to Chrome is working intermittently
Replies: 2
Views: 2664

Re: Sending CTRL+F to Chrome is working intermittently

Just solved it by using Idiot's Script and just inserting Send>F between the CTRL press & releases and it now works 100% of the time :D Thank you Idiot :D setfocus> - Google Chrome* Let>VK_control=17 Let>ExtendedKey=1 Let>KeyUp=2 Press ctrl LibFunc>user32.dll,keybd_event,r,VK_control,0,ExtendedKey,0...
by ocnuybear
Thu Aug 02, 2018 9:01 am
Forum: Beginners
Topic: [Solved] Sending CTRL+F to Chrome is working intermittently
Replies: 2
Views: 2664

[Solved] Sending CTRL+F to Chrome is working intermittently

I'm trying to send CTRL+F keys to Chrome to do a find on page and sometimes it works, sometimes not. Setting Let>SK_DELAY=100 is not making any difference Could this be a timing issue between the keys? Let>SK_DELAY=100 GetWindowHandle> - Google Chrome*,hWndParent SetFocus> - Google Chrome* FindObjec...
by ocnuybear
Tue Jul 31, 2018 1:25 pm
Forum: Enhancement Suggestions
Topic: MS GUI Enhancement Suggestions
Replies: 5
Views: 15531

MS GUI Enhancement Suggestions

1. Please add to the existing Toolbar Block Indent/Un-Indent/Comment

2. Add Dark Mode for background so it is easier on the eyes
Sign up to our newsletter for free automation tips, tricks & discounts