Search found 1352 matches

by Dorian (MJT support)
Wed Jul 28, 2021 12:20 pm
Forum: General Discussion
Topic: Study Macro Scheduler
Replies: 4
Views: 11015

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: 7
Views: 13030

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

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

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

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

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

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

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

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>SMTP_USERID=me@myemail.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>me=me@myemail.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: 2813

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

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...
by Dorian (MJT support)
Mon Jun 14, 2021 3:57 pm
Forum: Beginners
Topic: Automatically send email when macro completes
Replies: 6
Views: 9988

Re: Automatically send email when macro completes

For gmail you may need to enable 'less secure' apps and/or you might also need to create an app password:
https://support.google.com/accounts/ans ... 0255?hl=en
Sign up to our newsletter for free automation tips, tricks & discounts