Search found 1009 matches
- 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.
- 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.
- 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.
- 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.
- 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
- 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
- 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...
- 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.
- 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.
- 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...
- Mon Jul 26, 2021 4:58 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?
Ah! Might just do! Will try.
- 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...
- 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?
- 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!
- 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"?