Hello All,
I am getting a problem of closing a dialog.
Run on scripts then the dialog is closed perfectly. But it is not closed when run on executable file.
And the scripts run differently than the exe file. ???
Any ideas will be appreciated.
Thanks
Search found 132 matches
- Tue Apr 02, 2024 3:33 pm
- Forum: Beginners
- Topic: Closing Dialog
- Replies: 1
- Views: 1237
- Thu Jan 18, 2024 12:40 pm
- Forum: Beginners
- Topic: How to use onEvent
- Replies: 3
- Views: 3801
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...
- Thu Jan 11, 2024 2:37 pm
- Forum: Beginners
- Topic: How to use onEvent
- Replies: 3
- Views: 3801
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...
- Wed Sep 07, 2022 2:00 pm
- Forum: General Discussion
- Topic: Create and show multiple dialogs
- Replies: 6
- Views: 11462
Re: Create and show multiple dialogs
Thanks. It worked now.
- Wed Sep 07, 2022 12:45 pm
- Forum: General Discussion
- Topic: Create and show multiple dialogs
- Replies: 6
- Views: 11462
Re: Create and show multiple dialogs
And I am not able to set the dialog3 position to the second screen.
I am using these:
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
- Wed Sep 07, 2022 12:26 pm
- Forum: General Discussion
- Topic: Create and show multiple dialogs
- Replies: 6
- Views: 11462
Re: Create and show multiple dialogs
Thanks a lot Dorian.
- Tue Sep 06, 2022 5:46 pm
- Forum: General Discussion
- Topic: Create and show multiple dialogs
- Replies: 6
- Views: 11462
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
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
- Wed Aug 24, 2022 6:16 pm
- Forum: Beginners
- Topic: XLOpen does not open excel file
- Replies: 1
- Views: 11485
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
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
- Fri Apr 08, 2022 5:06 pm
- Forum: Beginners
- Topic: Add and delete columns in VBA
- Replies: 4
- Views: 12214
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...
- Thu Mar 10, 2022 2:08 pm
- Forum: Beginners
- Topic: Add and delete columns in VBA
- Replies: 4
- Views: 12214
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...
- Tue Oct 12, 2021 12:09 pm
- Forum: Beginners
- Topic: How to find quote and double quote position
- Replies: 4
- Views: 12561
Re: How to find quote and double quote position
Thanks Dorian.
Copy and paste. Easy
Copy and paste. Easy
- Tue Oct 12, 2021 9:59 am
- Forum: Beginners
- Topic: How to find quote and double quote position
- Replies: 4
- Views: 12561
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.
I tried it but did not work. That text is extracted from my pdf files and I think it is different formatted.
- Mon Oct 11, 2021 7:24 pm
- Forum: Beginners
- Topic: How to find quote and double quote position
- Replies: 4
- Views: 12561
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
I have a text = 0’ 2”
How to find the position of those quotes?
Thanks
- Thu Sep 30, 2021 1:00 pm
- Forum: Beginners
- Topic: How to extract element in array
- Replies: 6
- Views: 13922
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...
- Thu Sep 30, 2021 12:14 pm
- Forum: Beginners
- Topic: How to extract element in array
- Replies: 6
- Views: 13922
Re: How to extract element in array
Thanks a lot. It worked.