Search found 1009 matches

by Grovkillen
Tue Aug 03, 2021 2:48 pm
Forum: Technical / Scripting
Topic: Copy Range frome book 2 book Excel
Replies: 11
Views: 4691

Re: Copy Range frome book 2 book Excel

Well, I think it's pretty obvious. You're closing the document within Excel, this will of course make MacroScheduler become angry. Leave it out and close it with the XLQuit.
by Grovkillen
Tue Aug 03, 2021 2:46 pm
Forum: General Discussion
Topic: Release notes for 15.0.19?
Replies: 7
Views: 12285

Re: Release notes for 15.0.19?

Thank you for that. I'd like to have the release notes updated even if there's minor changes. It's better then leaving us in limbo.
by Grovkillen
Mon Aug 02, 2021 5:20 pm
Forum: Technical / Scripting
Topic: Copy Range frome book 2 book Excel
Replies: 11
Views: 4691

Re: Copy Range frome book 2 book Excel

Instead if using a VBScript chunk use the XLOpen and inject the VBA using the XLRunCode command.
by Grovkillen
Mon Aug 02, 2021 4:47 pm
Forum: Technical / Scripting
Topic: Get filename in var without path and extension
Replies: 7
Views: 3805

Re: Get filename in var without path and extension

Yes I believe the best way is to use VBA.
by Grovkillen
Mon Aug 02, 2021 8:42 am
Forum: Technical / Scripting
Topic: Get filename in var without path and extension
Replies: 7
Views: 3805

Re: Get filename in var without path and extension

Code: Select all

ExtractFileName>file_names_%k%,oldfilename,1
by Grovkillen
Wed Jul 28, 2021 1:40 pm
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 9
Views: 4279

Re: How delete duplicates from array?

Ah, that was one very important error on my part :D
by Grovkillen
Wed Jul 28, 2021 12:27 pm
Forum: General Discussion
Topic: Study Macro Scheduler
Replies: 4
Views: 10455

Re: Study Macro Scheduler

An addition to that list is to use this forum. Both as a way up search how others has done things but also by asking for input on your own problem. Make sure you cut your example code down to only examplify the problem and don't post full scripts. This also helps you to understand your own problem a...
by Grovkillen
Wed Jul 28, 2021 12:16 pm
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 9
Views: 4279

Re: How delete duplicates from array?

Use the variable inspector and step though your script using F8.
by Grovkillen
Wed Jul 28, 2021 7:22 am
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 9
Views: 4279

Re: How delete duplicates from array?

Yes you need to declare the empty string first. Look in the manual to get the correct syntax for the position command.
by Grovkillen
Wed Jul 28, 2021 7:00 am
Forum: Technical / Scripting
Topic: How delete duplicates from array?
Replies: 9
Views: 4279

Re: How delete duplicates from array?

Loop through the array and add new value to another string. GetClipBoard>List,0 Separate>List,CRLF,Array1 Let>uniqueList= Let>k=0 Repeat>k Let>k=k+1 Let>tempValue=Array1_%k% Position>tempValue,uniqueList,1,foundValue,False If>foundValue=0 Let>uniqueList=%uniqueList%| EndIf> Until>k=Array1_count Sepa...
by Grovkillen
Mon Jul 26, 2021 1:47 pm
Forum: Technical / Scripting
Topic: Assigned command not working on dynamic variable names?
Replies: 5
Views: 3521

Re: Assigned command not working on dynamic variable names?

I made an example as simple as possible just to keep it to the point. The thing is that I have dynamic variable assignment based on database values but as the example shows I cannot use variables inside the assigned command to see if a variable is assigned. Further info: the script I'm writing is fe...
by Grovkillen
Sun Jul 25, 2021 3:51 pm
Forum: Technical / Scripting
Topic: The Dialog values need refreshing ?
Replies: 1
Views: 2245

Re: The Dialog values need refreshing ?

Why not use a new window/dialog to show whatever error you want?
by Grovkillen
Fri Jul 23, 2021 8:08 pm
Forum: Scripts and Tips
Topic: Get Chrome version
Replies: 2
Views: 11493

Re: Get Chrome version

Thanks for the feedback. Good to know!
by Grovkillen
Thu Jul 22, 2021 5:47 pm
Forum: General Discussion
Topic: ZipExtractFiles and HTTPRequest large files, indication on progress?
Replies: 7
Views: 11923

Re: ZipExtractFiles and HTTPRequest large files, indication on progress?

Thanks! This one is what I'd like to know:
Would it be possible to make it non-blocking like RunProgram can be set to "not wait for completion"?
cron
Sign up to our newsletter for free automation tips, tricks & discounts