Thanks to both of you. I did find a code to use the excel reference so
it is working for me now
Thanks again for you much appreciated suggestions
Bob

On Tue, 27 Jan 2004 18:16:49 -0800, "Steve Gerrard"
 wrote:

>
>"Bob"  wrote in message
>news:bcia101n96crcvqjrtajr9pds27e536gp9{at}4ax.com...
>> I have a grid that I am currently exporting to csv. I export based on
>> a several queries and fill the grid then export. I would like to know
>> how I could do this into an excel spreadsheet. I thought I could do it
>> with a csv but realize I am clueless
>>
>> I just want to export and count whatever is in column A.
>>
>> Thanks
>> Bob
>
>Merijn has posts on using ADO to do this. Here are some other ideas.
>
>Excel will open a .csv file quite well, so you may want to just do that.
>On my machine, a .csv file is shown in Explorer as a "Microsoft Excel
>Comma Separated Values File".
>
>Another way is to set a reference in you VB project to the Microsoft
>Excel Object Library.
>Then you can declare variables such as
>    Dim oXL as Excel.Application
>    Dim oWB as Excel.Workbook
>    Dim oWS as Excel.Worksheet
>and use them to start up Excel, open a workbook, and add or modify a
>worksheet.
>
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 1/28/04 2:52:53 PM