I'm quite surprised that your method worked in the first place. I don't think we've ever had any support requests from anyone using XLOpen that way. Your assumptions are correct. The update now checks for the file. Being able to open remote files appears to be an undocumented side effect of Macro Sc...

I consulted Marcus about this, and he suggests it's a perfect candidate for python. A good starting point would be PyExec

We answered this via support.

I think Grovkillen is on the right track. I wouldn't mind betting if you were to copy and paste those 1061x18 into a new sheet it'll find the correct dimensions.

Another possible method is the to use the "_WRITE_LOG_FILE" system variable. When it is set to "0" logging is suspended until you reset it back to "1". If the script always fails in the same place or places, those may be the only places that need to be logged. Let>_WRITE_LOG_FILE=0 //Lines of code ...

I'd be more inclined to use GetFileList to get the list of files in the folder, then enter each path and filename as you loop through all the files.

I think I just answered this question via the help desk, so you'll see a more in-depth answer there.

The System Variable _LINE_NUM returns the current line being executed and may be a good starting point for what you're trying to do.

See it in action :

I asked Marcus about this and his response it's because the numbers are floating point numbers internally.

1. Is there a good way to automate clicking a button on a webpage, when a) the button is not currently shown on the page - it is scrolled down a few pages? and b) if the mouse is hovering over the button causing the tiny little pop up box to pop up and "cover" up the button... (in the situation whe...

Hi,

I think this article might answer your question : https://help.mjtnet.com/article/14-why- ... logged-out

That isn't what I'd have expected either. I'll ask Marcus about this, but in the meantime I would use the format command.

If I am understanding correctly, you want to process all the files in one folder, and save each output with the same file name as it's "master". The code below should give you enough to play with, if that is the case. //Set the location Let>FileLocation=d:\MJT\files //Get a list of all files in fold...

There are quite a few obstacles here, and these systems are designed to prevent humans from cheating in games. Getting around that isn't really what we're about at MJT. I would imagine the question text is not grabbable, but you can try using the Text Capture Wizard . If that fails, try OCRArea . OC...

I have another workaround for you on this. Sometimes the performance of the target app can be a real issue. I've seen apps or forms that wouldn't accept all the characters unless SK_delay was in the region of 400. This is a problem when some web forms won't accept the usual methods of using any Macr...