If the day is less than 13 you have no way of knowing which one it is. Is there a way of identifying if any of the first 4 characters are not numeric in one go, i.e. it would read 2024 as a number but 11-2 it would detect as not being a valid number, or do I need to check each character individuall...

That's a remarkably clever way of using Separate. I just used Position. Also that's a good point re the case, which I hadn't thought of, so added it. Here's what I had : Let>SearchString=en-GB UpperCase>SearchString,SearchString LabelToVar>codes,codelist UpperCase>codelist,codelist Position>Searchst...

F1 still launches context sensitive help, but we moved to online help quite some time ago.

Our hunch here is that ChromeDriver will not allow selenium to automate a chrome session that requires a hardware security method - for security reasons.

Added in 15.0.28

https://help.mjtnet.com/article/222-version-history

Not being a Regex guru, my approach would simply be to let that happen and then change it back again with another replace. I do realise that's somewhat of a bodge.

* "it's not wrong if it works" philosophy.

Many thanks. I'm always very grateful to the Regex gurus in here.

I'd also be inclined use ReadFile instead of ReadLn and then Between/Regex to get anything between dc:title and />

I think I'd do this in stages and take the approach of grabbing everything between content= and /> , use StringReplace to replace the &, then Regex to remove all non alphanumeric characters. But I'm no Regex expert - there may be others here who can do it all in one go. Let>TheHTML=<meta name="dc:ti...

GetFileDate : The date returned is in the format YYYYMMDD

DatePart : The date should be in a format recognised by the system.

We can use MidStr though.

We have just released Macro Scheduler 15.0.25

For more details please see the Version History Page or this Blog post.

JRL wrote: ↑

Wed Aug 21, 2024 1:22 pm

Dorian wrote:...and causing Excel to be "busy".

I don't have time to test but if multiple usage is the problem, might SHARING the files alleviate the issue?

I just tried it and unfortunately still had the same issue.

Excel can perform custom data verification... nodochau might have an alternate method to accomplish his task. I'm still curious about why XLGetCell> would crash if it is used to monitor cell input. Seems like this should work. I just experimented with your example and it throws that error even if I...

Excel can perform custom data verification, so this operation can be achieved entirely within Excel, taking the upper and lower values and giving a popup if anything outside those parameters is entered anywhere within a given range. It's in >Data >Data Verification >Data Tools I think then it's >Set...

I'd probably start in Beginners.