Search found 1346 matches

by Dorian (MJT support)
Fri May 03, 2019 10:55 am
Forum: The Water Cooler
Topic: Question about GetFileList to work..
Replies: 4
Views: 15729

Re: Question about GetFileList to work..

I'll see if I can walk you through how to build this in stages. We can often do this using code samples from the helpfile, and bolting them to what we have already. Let's start with the basic sample from the GetFileList helpfile entry, and adapt it a little. We've adapted it to only look for .jpg fi...
by Dorian (MJT support)
Thu May 02, 2019 10:36 am
Forum: Technical / Scripting
Topic: Excel Trouble
Replies: 12
Views: 8209

Re: Excel Trouble

The only ways I can force this error (and the only causes I have ever seen over at the Support Desk) are : 1) If the path and filename in XLGet is incorrect. But if XLOpen is working using that same path, it can't be that. or, 2)If the XL Book Handles in XLGet and XLGetCell don't match - of course I...
by Dorian (MJT support)
Mon Apr 29, 2019 11:21 pm
Forum: Technical / Scripting
Topic: SMTPSendMail with Gmail (SOLVED) - enable "Less Secure Apps"
Replies: 6
Views: 16459

SMTPSendMail with Gmail (SOLVED) - enable "Less Secure Apps"

We recently had a customer over at the support desk who just couldn't seem to get Macro Scheduler to send emails via Gmail. Although he was doing everything right, the email never got sent. There were no errors and SMTP_RESULT was always blank - it just didn't work. Here's the code I gave him, which...
by Dorian (MJT support)
Mon Apr 29, 2019 2:58 pm
Forum: Technical / Scripting
Topic: Excel Trouble
Replies: 12
Views: 8209

Re: Excel Trouble

XLGet attaches to an existing running instance of Excel. In other words, if that Excel file has been opened by anything other that XLOpen. I was able to replicate this error, so have a good idea of what may be causing it. This is my test code : //Working code let>filename=D:\mjt\files\excel\compare....
by Dorian (MJT support)
Fri Apr 26, 2019 12:09 pm
Forum: Technical / Scripting
Topic: [SOLVED] Launching xlsm from MS encounters errors.
Replies: 7
Views: 4298

Re: [SOVLED] Launching xlsm from MS encounters errors.

Aaah, that's great to hear. Thank you for the update.
by Dorian (MJT support)
Thu Apr 25, 2019 5:11 pm
Forum: Technical / Scripting
Topic: [SOLVED] Launching xlsm from MS encounters errors.
Replies: 7
Views: 4298

Re: Launching xlsm from GS encouters errors.

Hi, we'd be happy to help. Let's see if we can get to the bottom of it. What is GS? What error are you seeing? Can you share the pertinent part of your code please? The following is the code for opening an xlsm and running an Excel Macro using XLOpen and XLRun //Set up the document path let>filepath...
by Dorian (MJT support)
Wed Apr 24, 2019 3:36 pm
Forum: Beginners
Topic: Simulate Keyboard Shortcut
Replies: 1
Views: 2191

Re: Simulate Keyboard Shortcut

Hi,

Try...

Press CTRL
Press Shift
Send>N
Release Shift
Release CTRL

Occasionally this is too fast for some applications, so you can slow it down slightly with...

Press CTRL
Wait>0.05
Press Shift
Wait>0.05
Send>N
Wait>0.05
Release Shift
Wait>0.05
Release CTRL
by Dorian (MJT support)
Wed Apr 24, 2019 3:14 pm
Forum: General Discussion
Topic: Run script with Touch Screen
Replies: 1
Views: 4139

Re: Run script with Touch Screen

Just trap the onClick event as normal. It's no different.
by Dorian (MJT support)
Wed Apr 24, 2019 10:20 am
Forum: Technical / Scripting
Topic: Image Recognition Problem
Replies: 1
Views: 1621

Re: Image Recognition Problem

That's an interesting one. No, there's no way to ignore orientation. Are you able to capture all of the variations and try to detect all of them? Or are there too many permutations? Or maybe is there a small part of the image which may appear the be the same - for example if there's a unique block o...
by Dorian (MJT support)
Mon Apr 22, 2019 10:04 am
Forum: Beginners
Topic: Copy past to notepad in Repeat block Not working
Replies: 2
Views: 2841

Re: Copy past to notepad in Repeat block Not working

Does adding SetFocus make any difference? So you'd have :

WaitWindowOpen>Untitled - Notepad
MoveWindow>Untitled - Notepad,-1834,221
ResizeWindow>Untitled - Notepad,178,636
SetFocus>Untitled - Notepad

Wait>0.200
Press LCTRL
Wait>0.200
Send>v
Wait>0.200
Release LCTRL
Wait>0.500
by Dorian (MJT support)
Thu Apr 18, 2019 9:55 am
Forum: Beginners
Topic: Question about a video game
Replies: 2
Views: 3254

Re: Question about a video game

I just downloaded it and tried it. I have no idea what I'm supposed to do in Roblox, but I found that this will successfully move and click in the game. I just used it to click through the tutorial popups. Of course your mouse co-ordinates wil be different. Setfocus>Roblox MouseMove>1995,1327 lclick
by Dorian (MJT support)
Thu Apr 18, 2019 9:41 am
Forum: Beginners
Topic: Question about a video game
Replies: 2
Views: 3254

Re: Question about a video game

Have you tried making sure to set focus to the window you're trying to control?
by Dorian (MJT support)
Thu Apr 11, 2019 8:15 am
Forum: Technical / Scripting
Topic: HTTP_CUSTOM_HEADERS
Replies: 2
Views: 2226

Re: HTTP_CUSTOM_HEADERS

Hi Colin,

It's great to hear your issue was resolved.
by Dorian (MJT support)
Mon Apr 08, 2019 10:02 am
Forum: Technical / Scripting
Topic: Image recognition
Replies: 1
Views: 1461

Re: Image recognition

Would GetpixelColor or even WaitPixelColor be viable options for this?
Sign up to our newsletter for free automation tips, tricks & discounts