I just responded to this question via your support ticket, as your question there contained more specifics.

I see exactly what you mean. Thank you for bringing this to our attention. We've added it to the list of things for dev to look at.

I tried your code and didn't experience any performance issues, so it's difficult to test, but there are two things I might try. #1. I'm wondering if your use of n as a variable is interfering with the n in format. Format still seems to be working though, so this may be a red herring. See if this is...

It ran fine for me in 14.5.5. It gave me that error as soon as I clicked any buttons, but adding some empty subroutines fixed that. To answer your other question, nothing relating to Dialogs has been changed in 14.5.5. let>strLastFolder=Z:\ Dialog>Dialog1 object Dialog1: TForm Left = 635 Top = 307 H...

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