You're not giving the command a range. https://www.mjtnet.com/manuals/b/v15/to ... trange.htm
Use the XlGetCell instead: https://www.mjtnet.com/manuals/b/v15/to ... etcell.htm
Search found 1033 matches
- Fri May 31, 2024 7:27 pm
- Forum: Beginners
- Topic: Invalid Variant Operation error on XLGet
- Replies: 1
- Views: 30
- Fri May 31, 2024 12:32 pm
- Forum: The Water Cooler
- Topic: Any news from behind the scenes?
- Replies: 1
- Views: 57
Re: Any news from behind the scenes?
I was reading this post: https://help.mjtnet.com/article/185-how-frequently-do-we-release-new-versions and figured I could make it into a fun little analysis. Here's the list based on the version history page: HTTPRequest>https://help.mjtnet.com/article/222-version-history,,GET,,TEMP_html,,,, Let>RE...
- Thu May 30, 2024 4:27 am
- Forum: The Water Cooler
- Topic: Any news from behind the scenes?
- Replies: 1
- Views: 57
Any news from behind the scenes?
I'm curious about the future, what's in the pipe for MS in general?
- Wed May 15, 2024 4:43 pm
- Forum: Scripts and Tips
- Topic: DoBrowse to automatically popup a browse-for-file dialog
- Replies: 1
- Views: 256
Re: DoBrowse to automatically popup a browse-for-file dialog
And here's one with a filter: Let>WIN_USEHANDLE=1 Dialog>BrowseButtonDialog object BrowseButtonDialog: TForm Caption = 'BrowseButtonDialog' ClientHeight = 1 ClientWidth = 1 object BrowseButton: tMSButton Left = 0 Top = 0 Width = 1 Height = 1 TabOrder = 0 DoBrowse = False Filter = 'Text files|*.scp;*...
- Wed May 15, 2024 4:18 pm
- Forum: Scripts and Tips
- Topic: DoBrowse to automatically popup a browse-for-file dialog
- Replies: 1
- Views: 256
DoBrowse to automatically popup a browse-for-file dialog
I have not come to be a friend of the Input command since it's not very configurable and most of the time I just want to use it for adding a file path to the running script. I have come up with this little hack to make it more stream line. Let>WIN_USEHANDLE=1 Dialog>BrowseButtonDialog object BrowseB...
- Wed May 15, 2024 5:27 am
- Forum: General Discussion
- Topic: Block comment will maximize collapsed code blocks
- Replies: 3
- Views: 310
Re: Block comment will maximize collapsed code blocks
Removed was the wrong word for it, yes it unfolds any collapsed code blocks following the /* which is not wanted because you have collapsed them for a reason.
So you're replicating the problem.
So you're replicating the problem.
- Tue May 14, 2024 6:55 pm
- Forum: General Discussion
- Topic: Block comment will maximize collapsed code blocks
- Replies: 3
- Views: 310
Block comment will maximize collapsed code blocks
If I type /**/ to make a block comment the editor will remove any minimized code blocks following. Should not do that.
- Wed May 01, 2024 5:17 pm
- Forum: Enhancement Suggestions
- Topic: QR code generator/reader
- Replies: 0
- Views: 2572
QR code generator/reader
Is it possible to add internal QR code generation? Something like this: http://www.java4less.com/barcodedelphi/barcodesdelphi.php And as a follow up request, scan input image file for QR code and get QR data back (encoded data, position, rotation, skew etc.). http://www.java4less.com/vision/vision.p...
- Wed May 01, 2024 5:04 pm
- Forum: Enhancement Suggestions
- Topic: Minimizing all
- Replies: 0
- Views: 2237
Minimizing all
I'd like to see a "minimize all" command inside the Editor which minimize all the first level sub routines and block comments.
Also if possible have them listed as "bookmarks" for easier navigation in long code files.
Also if possible have them listed as "bookmarks" for easier navigation in long code files.
- Fri Apr 26, 2024 5:00 am
- Forum: Enhancement Suggestions
- Topic: RegEx replace match [UNDOCUMENTED FEATURE?]
- Replies: 9
- Views: 31116
Re: RegEx replace match [UNDOCUMENTED FEATURE?]
Global as in full match of the RegEx. It not being documented as in showing some examples with capturing groups.
The feature I'm asking for is to have the capturing groups put into an array (optional setting most likely).
The feature I'm asking for is to have the capturing groups put into an array (optional setting most likely).
- Wed Apr 17, 2024 9:14 am
- Forum: Enhancement Suggestions
- Topic: CopyFile documentation
- Replies: 5
- Views: 14140
Re: CopyFile documentation
Bump on this.
- Wed Apr 17, 2024 4:20 am
- Forum: Technical / Scripting
- Topic: WaitScreenImage Not Working With ScreenShot
- Replies: 3
- Views: 1738
Re: WaitScreenImage Not Working With ScreenShot
Graphics are not consistent. I tend to only use this approach on known machines that I myself have control over. Most likely the resolution isn't close enough to your machine's resolution. So your solution needs to be made on "new screenshot per new machine" premises I'd say. Or choose another appro...
- Thu Apr 11, 2024 8:18 am
- Forum: Enhancement Suggestions
- Topic: VBEval> gutter information incorrect
- Replies: 1
- Views: 2719
VBEval> gutter information incorrect
When having more than one variable passed to the VBscript function the gutter information will mistake the comma for a command comma and display the VBScript Expression as part of the Result Variable.
- Thu Apr 11, 2024 8:17 am
- Forum: Enhancement Suggestions
- Topic: [reviewed as not possible] Position Ask and Input dialogs
- Replies: 4
- Views: 3022
Re: [reviewed as not possible] Position Ask and Input dialogs
I got my own library made for these kinds of input. I just thought I'd add some suggestions to any future update
- Mon Apr 08, 2024 7:50 pm
- Forum: Enhancement Suggestions
- Topic: [reviewed as not possible] Position Ask and Input dialogs
- Replies: 4
- Views: 3022
Re: Position Ask and Input dialogs
All right, it was just a suggestion. I've already been creating my own dialogs and just thought the standard dialogs was possible to manipulate a bit. Let's mark this one as not possible.