Search found 942 matches

by Dorian (MJT support)
Tue Aug 03, 2021 2:51 pm
Forum: General Discussion
Topic: Release notes for 15.0.19?
Replies: 7
Views: 171

Re: Release notes for 15.0.19?

Agreed. I have updated this a moment ago.
by Dorian (MJT support)
Tue Aug 03, 2021 1:25 pm
Forum: General Discussion
Topic: Release notes for 15.0.19?
Replies: 7
Views: 171

Re: Release notes for 15.0.19?

From the desk of Marcus : The only change was to two sample scripts. There were no changes to the software. We have to update the version number when we publish a new build hence we just added the b suffix since this was very minor. We updated the Edge and Chrome sample scripts as we noticed they w...
by Dorian (MJT support)
Tue Aug 03, 2021 10:10 am
Forum: Technical / Scripting
Topic: Copy Range frome book 2 book Excel
Replies: 11
Views: 96

Re: Copy Range frome book 2 book Excel

Grovkillen is correct, this will open a password protected WorkBook - e.g. open the file. //XLopen>d:\pwtest.xlsx,1,xlh,test However, I think you mean the sheet is protected, not the file. I've never needed to do this before so I experimented a little, and my knowledge of VBA is almost zero. I was a...
by Dorian (MJT support)
Mon Aug 02, 2021 4:26 pm
Forum: Technical / Scripting
Topic: Copy Range frome book 2 book Excel
Replies: 11
Views: 96

Re: Copy Range frome book 2 book Excel

You don't need to adapt VBA for Macro Scheduler. Simply use XLRunCode and the VBA you've written. Or are you saying you can't use XLRunCode? Apologies if I am misunderstanding.
by Dorian (MJT support)
Mon Aug 02, 2021 3:15 pm
Forum: Technical / Scripting
Topic: Copy Range frome book 2 book Excel
Replies: 11
Views: 96

Re: Copy Range frome book 2 book Excel

Those who know VBA can probably give a VBA example which uses VBA to paste to the next blank row, but using a mixture of simple VBA to copy and paste a range, and Macro Scheduler to find the first blank row, the standalone example below will copy a range from Sheet1 and paste it into the first blank...
by Dorian (MJT support)
Mon Aug 02, 2021 10:00 am
Forum: Technical / Scripting
Topic: Run different macros from main macro
Replies: 2
Views: 25

Re: Run different macros from main macro

For that you can either use Include or Macro. the differences are explained at each of those links.
by Dorian (MJT support)
Thu Jul 29, 2021 9:43 am
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 9
Views: 149

Re: How delete duplicates from array?

Here's a self contained version in case it helps anyone else. I've tweaked it a bit so if the last item in Array1 is blank, it subtracts 1 from Array1_Count. This means it won't process the last item if it's blank, and we won't get the Pos error. Also seeing as the last item in Array2 is always blan...
by Dorian (MJT support)
Wed Jul 28, 2021 1:03 pm
Forum: General Discussion
Topic: Study Macro Scheduler
Replies: 4
Views: 85

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: 9
Views: 149

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: 4
Views: 85

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

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

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

Re: Get Newest Folder

Not with Macro Scheduler commands, but this thread shows how to do t with VBScript within Macro Scheduler.
Sign up to our newsletter for free automation tips, tricks & discounts