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...

I've tested and can replicate this in the 15.0.24 too. It seems to see all the windows with captions but not ones without. I have passed this on to dev for investigation.

I copied my files to c:\folder\chromefiles\chromeProfile\default to test and used the following. Tested and working : Let>CHROMEDRIVER_OPTIONS=--user-data-dir=/folder/chromefiles/chromeProfile/default OR Let>CHROMEDRIVER_OPTIONS=--user-data-dir=/folder/chromefiles/chromeProfile/default,--start-maxim...

Got it, thank you. I will pass this on.

I'm not able to replicate this. I can't make it remove any codeblocks, whether they're folded or unfolded. But as soon as I type /* anywhere above folded codeblocks they will unfold - but not be removed. Of course they don't do that if I select the code and then use >Edit >Block Comment (or Alt-E, M...

No to the first question. You're calling the entire script.

It will run that script and then continue at the line after Macro>....

Noted, thank you.