Search found 1352 matches

by Dorian (MJT support)
Mon May 20, 2019 11:29 am
Forum: Beginners
Topic: Automate website access?
Replies: 5
Views: 4278

Re: Automate website access?

Have you tried the Find IE Element Wizard yet? Start with creating an IE instance with IECreate . IECreate>IE[0] Then navigate that instance to your login page with IENavigate . IENavigate>IE[0],http://www.mjtnet.com/,ie_res Once you're there, you might want to add a little wait to make sure the pag...
by Dorian (MJT support)
Fri May 10, 2019 10:59 am
Forum: General Discussion
Topic: Position of spaces
Replies: 14
Views: 18007

Re: Position of spaces

I'm no Regex guru either, but does this small edit to your original script do what you're looking for? Let>str1=I go to Cali today. Let>str2=I won't go to Cali tomorrow. Let>WordList= Separate>str1,space,var1 Separate>str2,space,var2 Let>k=0 //mdl>%var2_count% Repeat>k Let>k=k+1 Position>var2_%k%,st...
by Dorian (MJT support)
Thu May 09, 2019 10:03 pm
Forum: The Water Cooler
Topic: Question about adding to a String
Replies: 2
Views: 14783

Re: Question about adding to a String

If it's doing what you want but you're struggling to make the string add to itself, try something like this : I just changed the "combined" line and added Let>combined= at the beginning. Let>combined= Let>SourceFolder=d:\temp Let>RemoteFolder=http://www.visuell3d.se/test/sounds/ GetFileList>%SourceF...
by Dorian (MJT support)
Wed May 08, 2019 12:28 pm
Forum: Technical / Scripting
Topic: Need help for a script
Replies: 6
Views: 4083

Re: Need help for a script

You have the incorrect usage of Repeat/Until

You have this :

Code: Select all

Repeat>
//snipped
Until>FindImagePos>C:\Users\Seven\Desktop\bots\test 
The best place to find out about the correct usage and see a sample is here : Repeat
by Dorian (MJT support)
Wed May 08, 2019 12:03 pm
Forum: The Water Cooler
Topic: Question about GetFileList to work..
Replies: 4
Views: 16618

Re: Question about GetFileList to work..

It's great to see you're getting on so well with it. well done, Daniel.
by Dorian (MJT support)
Tue May 07, 2019 10:52 am
Forum: Technical / Scripting
Topic: Need help for a script
Replies: 6
Views: 4083

Re: Need help for a script

Being familiar with Horizon 4, I'd say this is going to be quite a challenge. I think it's highly unlikely that the text will be accessible and you'd have to rely entirely on Image Recognition and maybe looking out for pixel colours. And the trouble with Image Recognition I foresee is that whatever ...
by Dorian (MJT support)
Fri May 03, 2019 10:55 am
Forum: The Water Cooler
Topic: Question about GetFileList to work..
Replies: 4
Views: 16618

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: 8497

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: 16933

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: 8497

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: 4397

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: 4397

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: 2262

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: 4207

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: 1656

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...
cron
Sign up to our newsletter for free automation tips, tricks & discounts