Exporting Access listbox data to excel

[tfoulkes]

Hi all,

I've got a list box returning values in two columns.
I want to export this data to Excel to create charts etc.

I was wondering if anybody had any advice on how to do this?

Thanks
Tim

 

[dyarwood]

If the data is in a table the export it using

DoCmd.TransferSpreadsheet

dyarwood

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

although the main focus is Excel via the web, some of the code and the links may assist.

 

[tfoulkes]

Unfortunately it's not in a table.
The data is in a list box and is generated from VB code.
It is the result of a search which all works fine.

I've had a really good crack at this and can't work it out.

Ta!

 

[tfoulkes]

thanks ggriffit,

thats quite handy.

Tim