Search found 1352 matches
- 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...
- Thu Jul 22, 2021 10:40 am
- Forum: Technical / Scripting
- Topic: Assigned command not working on dynamic variable names?
- Replies: 5
- Views: 3886
Re: Assigned command not working on dynamic variable names?
I've marked this for Marcus' attention.
- Thu Jul 22, 2021 8:19 am
- Forum: General Discussion
- Topic: ZipExtractFiles and HTTPRequest large files, indication on progress?
- Replies: 7
- Views: 13005
Re: ZipExtractFiles and HTTPRequest large files, indication on progress?
I'll ask him again.
- 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.
- 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.
- 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.
- 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...
- 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...
- 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.
- 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.
Simply open it with XLOpen (as you may already be doing), and after it's finished processing use XLSave and XLQuit.
- 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...
- 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=...
- 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...
- Mon Jun 14, 2021 8:33 pm
- Forum: Beginners
- Topic: Automatically send email when macro completes
- Replies: 6
- Views: 9988
Re: Automatically send email when macro completes
Always happy to help.
- 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
https://support.google.com/accounts/ans ... 0255?hl=en