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

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...

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...

Thanks. It worked now.

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

Thanks a lot Dorian.

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

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

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...

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...

Thanks Dorian.
Copy and paste. Easy

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.

Hello All,
I have a text = 0’ 2”
How to find the position of those quotes?
Thanks

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...

Thanks a lot. It worked.