I have a long list of x,y coordinates in an excel file in column A and Column B. I have a program I wrote in GW Basic that checks some conditions of an x, y point. Currently, I input the x, and y manually. What I would like to do is read into GW basic one point after another from the excel (.csv) file, work with that point in my program, output the answer to a new or the existing file .csv file and then go to the next point, etc. Any advise? I'm figuring it will involve a OPEN, input#, etc. commands, but I can't get them right.
Thanks in advance.
JohnnyB
Reading .csv file into GW Basic
Moderators:Administrator, Global Moderator
Re: Reading .csv file into GW Basic
You could drag the mouse to the desired Excel columns and copy, and then open the "EDIT.COM" and paste, and "Save" with any other name. The data will enter the EDIT.COM tabulated with the same formatting of Excel.
After that, your GWBasic program could open it and change it in their own way.
However, would not be possible to return the changes back to Excel through GWBasic programming line.
After that, your GWBasic program could open it and change it in their own way.
However, would not be possible to return the changes back to Excel through GWBasic programming line.