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.

Have you tried this? : XLGetSelectedCell>xlBook,data_%k%,intRow,intCol It'll then be in an array. You don't need this line : Let>data=%data% %k% Then to output the data you can do something like this : ArrayCount>data,count let>OutputLoop=0 repeat>OutputLoop Let>OutputLoop=OutputLoop+1 MDL>data_%Out...

This should get you started. The principle is to open the Excel file first, before the loop, then add one to Row in a loop : //PseudoCode XLOpen>... Let>Row=0 Repeat>This Let>Row=Row+1 XLSetCell>xlh,Sheet1,%Row%,%Col%,Some Data,res Until>This,Something Here's a standalone version that demonstrates t...

This was a bit beyond me so I asked Marcus.

This is what he had to say :

If it's compiled, enable logging, run it and when the error occurs don't close error but grab log file, see where it got to

.

I will pass this along.

I just double-checked and app passwords are working with Outlook and RetrievePOP3. App Passwords . You'll also need to let Apps and Devices use POP >Outlook.com > Mail >Sync Email >Let Devices and Apps use POP This is the code I used : //Retrieve POP3 let>POP3_STATUS=1 let>popserver=outlook.office36...