Search found 935 matches

by Dorian (MJT support)
Wed Jul 28, 2021 1:03 pm
Forum: General Discussion
Topic: Study Macro Scheduler
Replies: 3
Views: 15

Re: Study Macro Scheduler

Totally agreed. :)
by Dorian (MJT support)
Wed Jul 28, 2021 12:41 pm
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 7
Views: 35

Re: How delete duplicates from array?

Grovkillen is on his phone, and I must say he did a better job than I could have done off the top of my head. I think part of the problem was that %tempValue% wasn't being appended to %uniqueList%. The Position error you mentioned happens when the last array item is blank, so if you're selecting a b...
by Dorian (MJT support)
Wed Jul 28, 2021 12:20 pm
Forum: General Discussion
Topic: Study Macro Scheduler
Replies: 3
Views: 15

Re: Study Macro Scheduler

Generally everything is in English. Let's look at the best resources for you : 1. When you're in the editor and have a command selected, press F1 to see context sensitive help file for that command. 2. The Command Reference . Every command in alphabetical order. 3. The Knowledgebase . Type something...
by Dorian (MJT support)
Thu Jul 22, 2021 8:18 am
Forum: General Discussion
Topic: Release notes for 15.0.19?
Replies: 4
Views: 103

Re: Release notes for 15.0.19?

I wasn't aware of this until you posted here so have asked Marcus for info. Will let you know as soon as I find out.
by Dorian (MJT support)
Mon Jul 12, 2021 6:03 pm
Forum: Technical / Scripting
Topic: Array and regex in Excel
Replies: 3
Views: 71

Re: Array and regex in Excel

Good catch. Edited.
by Dorian (MJT support)
Mon Jul 12, 2021 5:00 pm
Forum: Technical / Scripting
Topic: Get Newest Folder
Replies: 2
Views: 93

Re: Get Newest Folder

Not with Macro Scheduler commands, but this thread shows how to do t with VBScript within Macro Scheduler.
by Dorian (MJT support)
Mon Jul 12, 2021 10:16 am
Forum: Technical / Scripting
Topic: Array and regex in Excel
Replies: 3
Views: 71

Re: Array and regex in Excel

I just tested this and it does what I think you want. Writing the numbers into column B. Let>pattern=((?<=text A ).*(?= text B)) GetClipBoard>List,0 Separate>List,CRLF,Array1 XLOpen>C:\Users\I\Docs\doc.xlsm,1,xlBook Let>k=0 Repeat>k Let>k=k+1 Let>A1=Array1_%k% RegEx>pattern,A1,0,matches1,num,0 //Mes...
by Dorian (MJT support)
Sun Jul 04, 2021 5:52 pm
Forum: Technical / Scripting
Topic: How to open links in two diffrent browsers?
Replies: 8
Views: 205

Re: How to open links in two diffrent browsers?

Thank you so much! :D These are two working versions: RunProgram>C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe http://www.cnn.com RunProgram>cmd /C start microsoft-edge:http://www.cnn.com The first is the method I use. :D RunProgram>C:\Program Files (x86)\Microsoft\Edge\Application\m...
by Dorian (MJT support)
Fri Jul 02, 2021 8:24 pm
Forum: Beginners
Topic: EXE compile error
Replies: 1
Views: 134

Re: EXE compile error

This is almost always because some kind of security software prevented the compiler from installing. Disable that and reinstall.
by Dorian (MJT support)
Fri Jul 02, 2021 5:44 pm
Forum: General Discussion
Topic: Schedule A Macro To Run With Scheduled Tasks
Replies: 1
Views: 124

Re: Schedule A Macro To Run With Scheduled Tasks

Yes of course.

Simply open it with XLOpen (as you may already be doing), and after it's finished processing use XLSave and XLQuit.
by Dorian (MJT support)
Wed Jun 23, 2021 6:05 pm
Forum: Beginners
Topic: Automatically send email when macro completes
Replies: 6
Views: 356

Re: Automatically send email when macro completes

If it's Office 365 you could try something like this. Let>server=smtp.office365.com Let>SMTP_AUTH=1 Let>[email protected].com Let>SMTP_PASSWORD=Password Let>SMTP_PORT=587 Let>SMTP_SSL=1 Let>SMTP_USETLS=3 Let>subject=Hello Let>body=Please find the attached Let>[email protected].com Let>myname=John S...
by Dorian (MJT support)
Fri Jun 18, 2021 9:08 am
Forum: Technical / Scripting
Topic: Dropdown Box in Chrome
Replies: 2
Views: 160

Re: Dropdown Box in Chrome

If you right click on that element you can see it's in a frame. "View frame source" often gives us all the information we need to switch to that frame. So we find frames, switch frames, interact, switch back. Like this : //Find the frame using xpath ChromeFindElements>session_id,xpath,//iframe[@src=...
by Dorian (MJT support)
Tue Jun 15, 2021 7:49 am
Forum: Technical / Scripting
Topic: FindImagePos
Replies: 5
Views: 248

Re: FindImagePos

I may have picked up on the version if the post was in English. We don't support version 11 as it's 11 years old. To answer the move/size window question, these were all introduces in V5 : http://www.mjtnet.com/manual/index.html?windowaction.htm https://www.mjtnet.com/manual/index.html?resizewndow.h...
cron
Sign up to our newsletter for free automation tips, tricks & discounts