Output to Excel from VBA

[GraeagleBill]

What's involved in writing directly to a Excel file (xls)? I currently have an application that is writing comma separated strings to a csv file, but it would be more desirable if I could create an xls file instead.



I found a couple of examples, but they pertained to A2007. I need to keep the current application in A2003

Thanks,
Bill

[pbaldy]

Options include OutputTo, TransferSpreadsheet, and automation:

http://support.microsoft.com/kb/247412

There's a good chance that whatever method you found for 2007 would work in 2003.

[GraeagleBill]

Paul,

It looks like a winner, as the data is already in a two dimensional array, so can easily be written to a corresponding range of cells.

Thanks,
Bill

[pbaldy]

Happy to help Bill.