Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mike pretended :
The algebraic modeler is MPL of Maximal Software. When I had the table in Excel, you can go around the problem by adding a LHS ' to every element whether it is number or text. Now, when I saved the Excel file as a csv it no longer accepts an index that has some elements as numbers while others are text (like CW)?! Mike, So what you're saying is that 'Excel' removes the apostrophes when saving as CSV so that when reopening the file later the data no longer has apostophes on the LHS? Perhaps you need a custom import procedure that ensures the apostrophes are placed if missing? If so.., read the entire CSV into an array and place apostrophes where needed. If MPL reads from Excel then dump the array into a worksheet. -OR- If MPL reads in from the CSV directly then dump the array back into the CSV. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |