Search found 96 matches

by nodochau
Wed Feb 12, 2020 6:52 pm
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1517

XLSheetToArray

Hello All, I have an Excel spreadsheet that has Customer name and Purchase Orders info. I am using XLSheetToArray to find the customer name and return the Order. The customer name is Mani but my program does not find it. Do I miss something? Here is my code: XLSheetToArray>C:\BH\service-1.xls,Sheet1...
by nodochau
Tue Feb 11, 2020 11:49 am
Forum: Beginners
Topic: Set return value of dialog1 to dialoge2
Replies: 2
Views: 638

Re: Set return value of dialog1 to dialoge2

Thank you so much JRL.
by nodochau
Mon Feb 10, 2020 7:21 pm
Forum: Beginners
Topic: Set return value of dialog1 to dialoge2
Replies: 2
Views: 638

Set return value of dialog1 to dialoge2

Hello All, I have set two dialogs and try to get the return value from dialog1 (Edit property) and set it into dialog2 (Edit property). I have no success to do it. After I click Button A and B and I will have the variable name=AB in dialog1. But I can not use that variable %name% to set into the Edi...
by nodochau
Fri Feb 07, 2020 2:14 pm
Forum: Beginners
Topic: Loop to get data in Edit box property
Replies: 1
Views: 473

Loop to get data in Edit box property

Hello All,
I have a dialog which has 15 Edit boxes in there. I tried to get the data from those by using Repeat ..until but I could get data from the first Edit box only.
Please help.
by nodochau
Thu Feb 06, 2020 4:28 pm
Forum: Beginners
Topic: WriteLn Command
Replies: 5
Views: 682

Re: WriteLn Command

Thank you Grovkillen,
Is there anyway to not delete the file? Like C++ ofstream we don't need to delete it :)
by nodochau
Thu Feb 06, 2020 2:09 pm
Forum: General Discussion
Topic: Generating MSButton base on variable
Replies: 7
Views: 1354

Re: Generating MSButton base on variable

Thanks Grovkillen,
I will try it today.
by nodochau
Thu Feb 06, 2020 1:52 pm
Forum: Beginners
Topic: WriteLn Command
Replies: 5
Views: 682

WriteLn Command

Hello All,
Is there any parameter to be set so that when I execute WriteLn command and it just writes new lines in file. All the current lines in file will be truncated. By default when I execute WriteLn and it writes new lines below them.
Thank you for your help.
by nodochau
Thu Feb 06, 2020 11:11 am
Forum: General Discussion
Topic: Generating MSButton base on variable
Replies: 7
Views: 1354

Re: Generating MSButton base on variable

I agreed cause I don't know the number of buttons that need to be shown on the dialog. I can change the size of dialog base on the number of "clicking" the button and I would like to show the button that represent the info that I did. I know I can create a bunch of buttons and set visible to false b...
by nodochau
Wed Feb 05, 2020 1:27 pm
Forum: General Discussion
Topic: Generating MSButton base on variable
Replies: 7
Views: 1354

Generating MSButton base on variable

Hello All,
I just wondering that are we able to add the MSButton into a dialog automatically as soon as the variable is set?
Let say if I set the variable to 1 then one MSButton is created...
Thanks for your help.
by nodochau
Tue Feb 04, 2020 11:30 am
Forum: Technical / Scripting
Topic: How do I create a button that doesn't close a dialog?
Replies: 5
Views: 627

Re: How do I create a button that doesn't close a dialog?

bossydog9 wrote:
Sun Feb 02, 2020 3:13 am
I want a button in a dialog that performs a subroutine and nothing else. I want the dialog to stay open. I have added an AddDialogHandler statement that performs the subroutine, but the dialog closes. How do I stop it?
If you have a button in your dialog then just set its ModalResult = 0.
by nodochau
Thu Jan 30, 2020 1:14 pm
Forum: Technical / Scripting
Topic: Getting Specific Data From Excel
Replies: 14
Views: 5022

Re: Getting Specific Data From Excel

Dorian (MJT support) wrote:
Wed Jan 29, 2020 9:11 pm
I've reported this to dev as it might be a bug. You're not doing anything wrong - we both experienced the same results.

In the mean time it's easy enough to work around - just set your loop limit one less than length, or add some checks and balances in.
It sounds good now. Thanks again Dorian.
by nodochau
Thu Jan 23, 2020 5:35 pm
Forum: Beginners
Topic: HIGHLIGHTER
Replies: 5
Views: 868

Re: HIGHLIGHTER

Thank you.
by nodochau
Thu Jan 23, 2020 2:16 pm
Forum: Beginners
Topic: HIGHLIGHTER
Replies: 5
Views: 868

HIGHLIGHTER

Hi All,
I create a dialog which has a Edit box and set value for it. When I show the dialog how to get rid of the highlighter in the box?
Please see attachment.
Editbox.png
Editbox.png (53.26 KiB) Viewed 868 times
by nodochau
Thu Jan 23, 2020 1:43 pm
Forum: Beginners
Topic: Minimize Button For Dialog
Replies: 4
Views: 637

Re: Minimize Button For Dialog

Great!
Thank you.
Sign up to our newsletter for free automation tips, tricks & discounts