Hi JRL, This is what I am looking for. I have an data excel file and data will be within +tolerance and -tolerance. Can you show me how to create a graph in dialog? My data looks like this: +TOL=0.005 -TOL=-0.005 data in one column: 1.004, 0.996, 1.003..... So the nominal dimension is 1 and the grap...

Just wanted to give you an update. I copy some data from the Sheet that I get the issue with and paste them into the new one so that I have new (created with brand new excel sheet) and old (copied from the issue sheet) data in my new sheet. Code works OK with new data and does not work with old dat...

Grovkillen wrote: ↑

Thu Feb 13, 2020 3:18 pm

If you read the manual you'll see that the XL commands are XLS compatible only.

That is the reason why I save it as a xls format.

Just wanted to give you an update. I copy some data from the Sheet that I get the issue with and paste them into the new one so that I have new (created with brand new excel sheet) and old (copied from the issue sheet) data in my new sheet. Code works OK with new data and does not work with old data.

It seems like there are some problems with my spreadsheet. I don't know why. Just created a new one and code worked find. The file that I get the issue with was a xlsx file and I saved it as xls to use the command. Will it be a problem?? Any ideas? Or people at my work are using some unknown format ...

Yes I did. Did a debug line by line and it did not stop at the customer Mani. Any spaces, strings..related??

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

Thank you so much JRL.

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

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.

Thank you Grovkillen,
Is there anyway to not delete the file? Like C++ ofstream we don't need to delete it

Thanks Grovkillen,
I will try it today.

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.

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

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.