opening an excel file for reading

[bitwise]

I have to convert an excel file into a *.cvs (comma value separated) or *.tvs (tab value separated) file. Essentially I just want to open the excel file, run through each row converting each row into a line in the destination file separted appropriately (, or \t). I have everything done except for of course opening the excel file and going through it. If someone could give me some tips on how this could be done it would be most helpful as this is my very first VB app I have ever done.

Thanks,
-bitwise

 

[dsi]

Use the GetObject or CreateObject method to open/attach to Excel. Then, if you want the code for saving as a .cvs file, just record a macro while manually performing the task.

 

[ratman]

hi....try recording a macro in Excel and saving your file as a text file......treak it from there......if you need more help I can get into it more just email me at:

drat@mediaone.net



Ratman