how to open a excel file in vb 6.0
Posted on 2003-03-25
does anyone know how i can handle the following problem?
In form1 I open my standard excel document (standard.XLS), put some new textlines in it and save it under another name (for example: Document1.XLS). So far so good... But in form2 I want to open the just saved file (Document1.XLS) by clicking on a command button , and again edit some textlines (out of textboxes in VB) and save it again as Document1.xls.
The next time I start my program I want to edit standard.XLS again and save it as document2.XLS or something like that open it in form2 etc, etc, etc.
The thing is that I always open the standard document but save it under another name. in form two i want to open the new made document for edit.
Who can help me?