Search found 131 matches

by nodochau
Thu Jan 18, 2024 12:40 pm
Forum: Beginners
Topic: How to use onEvent
Replies: 3
Views: 1819

Re: How to use onEvent

Thanks a lot for your response. I have some questions. Why do you use the double quotes for subroutine? And codes don't work. I added some delay time and it worked but sometime it did not work I don't know. Below is my revised code: XLOpen>C:\Users\Documents\149405.xlsx,1,xl Wait>3 Let>row=15 Let>co...
by nodochau
Thu Jan 11, 2024 2:37 pm
Forum: Beginners
Topic: How to use onEvent
Replies: 3
Views: 1819

How to use onEvent

Hello ALl, I am try to create a script that monitor a cell in the spreadsheet. When the operator enter a bad value then a warning popup window will occur. When excel is opened and I enter the value into that cell, nothing happen if the value is out of Specification. But the code does not work. I app...
by nodochau
Wed Sep 07, 2022 2:00 pm
Forum: General Discussion
Topic: Create and show multiple dialogs
Replies: 6
Views: 9665

Re: Create and show multiple dialogs

Thanks. It worked now.
by nodochau
Wed Sep 07, 2022 12:45 pm
Forum: General Discussion
Topic: Create and show multiple dialogs
Replies: 6
Views: 9665

Re: Create and show multiple dialogs

And I am not able to set the dialog3 position to the second screen.
I am using these:

Code: Select all

SetDialogProperty>Dialog1,,Left,0
SetDialogProperty>Dialog1,,Top,10
SetDialogProperty>Dialog2,,Left,800
SetDialogProperty>Dialog2,,Top,10
SetDialogProperty>Dialog3,,Left,1920
SetDialogProperty>Dialog3,,Top,10
by nodochau
Wed Sep 07, 2022 12:26 pm
Forum: General Discussion
Topic: Create and show multiple dialogs
Replies: 6
Views: 9665

Re: Create and show multiple dialogs

Thanks a lot Dorian.
by nodochau
Tue Sep 06, 2022 5:46 pm
Forum: General Discussion
Topic: Create and show multiple dialogs
Replies: 6
Views: 9665

Create and show multiple dialogs

Hello All,
How to create 2 or three dialogs and show them all on screen?
I would like to create two of them and show each of them on my two screens. (one screen one dialog)

Thanks
by nodochau
Wed Aug 24, 2022 6:16 pm
Forum: Beginners
Topic: XLOpen does not open excel file
Replies: 1
Views: 9812

XLOpen does not open excel file

Hello All,
I am not able to open excel file by using xlopen command on Windows 10 pro.
Any advices?
XLOpen>C:\Users\mabdulah\Documents\QSF-Template\QSF.xlsx,1,xl
Thanks
by nodochau
Fri Apr 08, 2022 5:06 pm
Forum: Beginners
Topic: Add and delete columns in VBA
Replies: 4
Views: 10354

Re: Add and delete columns in VBA

Can you please share your spreadsheet with us , so that we can help with almost accuracy? I am also curious about this, I am new to learning VBA. Insert Column: VBStart Dim i, start_col, end_col, y Dim link Sub Insert_col(link, j, save_link, x) y = x - 6 Const xlToRight = -4161 Set objExcel = Creat...
by nodochau
Thu Mar 10, 2022 2:08 pm
Forum: Beginners
Topic: Add and delete columns in VBA
Replies: 4
Views: 10354

Add and delete columns in VBA

Hello all, I am trying to use VBA to add and delete columns in my spreadsheet. The VBA just works for adding. Deleting not working at all. The spreadsheet template is designed with 8 samples and sample number one starts at column 6. The goal is: If job has more than 8 samples then macro will add mor...
by nodochau
Tue Oct 12, 2021 12:09 pm
Forum: Beginners
Topic: How to find quote and double quote position
Replies: 4
Views: 10180

Re: How to find quote and double quote position

Thanks Dorian.
Copy and paste. Easy :)
by nodochau
Tue Oct 12, 2021 9:59 am
Forum: Beginners
Topic: How to find quote and double quote position
Replies: 4
Views: 10180

Re: How to find quote and double quote position

Thanks Dorian but it is not single or double quote on the keyboard.
I tried it but did not work. That text is extracted from my pdf files and I think it is different formatted.
by nodochau
Mon Oct 11, 2021 7:24 pm
Forum: Beginners
Topic: How to find quote and double quote position
Replies: 4
Views: 10180

How to find quote and double quote position

Hello All,
I have a text = 0’ 2”
How to find the position of those quotes?
Thanks
by nodochau
Thu Sep 30, 2021 1:00 pm
Forum: Beginners
Topic: How to extract element in array
Replies: 6
Views: 11566

Re: How to extract element in array

I change my code a little bit. And why the repeat loop does not work though?? I create 3 array first and then go to sub program to add values in each array. Let>text1=Names Let>text2=ID Let>text3=Status Let>k=0 Repeat>k Add>k,1 Let>text=text%k% ArrayDim>%text%,3 Gosub>text Until>k=3 SRT>Names Let>Na...
by nodochau
Thu Sep 30, 2021 12:14 pm
Forum: Beginners
Topic: How to extract element in array
Replies: 6
Views: 11566

Re: How to extract element in array

Thanks a lot. It worked.
by nodochau
Thu Sep 30, 2021 10:00 am
Forum: Beginners
Topic: How to extract element in array
Replies: 6
Views: 11566

Re: How to extract element in array

Thank you for your help.
I tried and I got <array>_1 from MDL.
Did I miss something?
Sign up to our newsletter for free automation tips, tricks & discounts